What is the problem with this query

J

Jack

I have the following query generated from a asp page, which uses access as
the back end.

Now, I am inserting the query in the sql view and trying to run it. At this
point, it
gives me syntax error. Not sure where the problem is. Any help is
appreciated in advance.

INSERT INTO tblExpense (ENO, Date, ContractedServiceExpense, TravelExpense,
PersonnelExpense) VALUES('1', '03/30/2005', '10', '5', '10')
 
D

Duane Hookom

I expect your use of single quotes as delimiters for all values is the
issue. Numeric fields don't use any delimiters and date fields use "#".
 
Top