Re: Why is this query not working in Access??

i'd rename that 'date' column to something other than date. It's a reserved word in access. hth, charlie Bob Wilson writes: html Hello,br br Any help is appreciated here.nbsp; I'm using code I've used before, butbr Access keeps giving me a syntax error.nbsp; br br Here is the

Re: Why is this query not working in Access??

Looks like you have single quotes around a date field '#date#' take the quotes out ... You do not put quotes around dates and numbers Paul Giesenhagen QuillDesign - Original Message - From: Bob Wilson [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, August 19, 2002 2:46

Re: Why is this query not working in Access??

Also Date being a reserved word might be causing you problems Cheers Brian - Original Message - From: Paul Giesenhagen [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, August 19, 2002 8:34 PM Subject: Re: Why is this query not working in Access?? Looks like you have

RE: Why is this query not working in Access??

actually you can quote dates as long as the format is correct... if it is wrong you'll get a datatype mismatch error. You'll want to hard-code values in place of each variable in the VALUES() clause one at a time until you figure out which one is giving you a problem and work from there...

Re: Why is this query not working in Access??

I can vouch for that... boy, it's been a long time, but I remember 5 years ago when I got started with all this, the guy who'd installed CF 3 before me had used Date for the name of a column in his access db... which worked fine as long as you used cfinsert and cfupdate ... using cfquery resulted