looks like a formatting issue, Access is a bit odd in that regard. The 

quickest approach  is to print your SQL before you run it and then see if 

it runs in an Access Query.



At 21:35 29/11/01 +0000, you wrote:

>I cannot get rid of a syntax error in my update script:

>

>"Update PatronDebits set LName='"&Request("sLname")&"', FName='"&Request

>("sFname")&"', StudID='"&Request("sIDnum")&"', Account='"&Request("sAcct")

>&"', Amount="&Request("sAmnt")&", Date=#"&Date()&"#, Clerk='"&Session

>("clerk")&"' where ID = "&Request("sItem")

>

>If I remove the Date, it works as in script below:

>

>"Update PatronDebits set LName='"&Request("sLname")&"', FName='"&Request

>("sFname")&"', StudID='"&Request("sIDnum")&"', Account='"&Request("sAcct")

>&"', Amount="&Request("sAmnt")&", Clerk='"&Session("clerk")&"' where ID

>= "&Request("sItem")

>

>I cannot figure this one out.  Please help.

>

>Ken W.

>




>

>Read the future with ebooks at B&N

>http://service.bfast.com/bfast/click?bfmid=2181&sourceid=38934667&categoryid=rn_ebooks