Error in Query

[M. Imran]

Hello,
Can any one tell what is problem in the following query, when I run this in a MS Access 2000 db from a java application it give error 'Syntax error in INSERT INTO statement' where date, desc, and memo fields are text type while other all are numeric.
query is : INSERT INTO Assets (transnum, acc_number, date, desc, memo, debit, credit, quantity, rate) VALUES ('10', '10', 'x', 'x', 'x', '10', '10', '10', '10' )
I will be very grateful to you,
Thank you,
Imran

[vidya archana]

u dont have to use quotes for numerical values.

[Nathan Pruett]

I'm moving this to a more appropriate forum than Swing/JFC/AWT, since this question has nothing to do with building GUIs...