Access 2007 CurrentDb.Execute problem

Topic

New Reply

I have a table called tblAllocate.
One of the fields is a lookup field called Job# which has numbers in it eg 55548 and the field in the table it looks to is definitely a number field.
I am trying to do the following in a button code on a form:

CurrentDb.Execute “DELETE * FROM tblAllocate WHERE Job# = ” & [Job#]

but I get the error

Run-time error ‘3075’:

Syntax error in date in query expression ‘Job# = 55548’

but I don’t have any dates in the table or expression?????

Help?

Reply | Quote

Replies

The use of # in the field name is causing the problem. # is used to precede dates in SQL.

It is best to avoid all special characters in field names. Can you rename the field to JOBID?

Reply | Quote

Thanks John,

Done and done! Problem solved.

Reply | Quote