Please help with syntax error

[visidro]

I am having trouble seeing the error in this line ......



CurrentDb.Execute "INSERT INTO Payments(EnrollmentDate, firstname, lastname, amount, program, classtype, pdate) SELECT inactive date, firstname, lastname, totalamount, program, classtype, Date() AS TodayDate FROM [Students Database Table] WHERE [inactive date]>#" & processingdate & "#;"


Could some one help me see the syntax error ... it lists 'Inactive date' field as the problem
Thank you

[June7]

Names with spaces or special characters/punctuation (underscore is exception) or are reserved words must be enclosed in [].

This is why it is a good idea to avoid those features in naming convention.

[ranman256]

Dont run Sql this way. Put it in a query.
Even if you Use form params. , use queries. NOT CODE.
or try
docmd.runSql sSql

[visidro]

I know now .... it would take a big effort to change this field name now

I tried this with same syntax error

CurrentDb.Execute "INSERT INTO Payments(EnrollmentDate, firstname, lastname, amount, program, classtype, pdate) SELECT [inactive date], firstname, lastname, totalamount, program, classtype, Date() AS TodayDate FROM [Students Database Table] WHERE [inactive date]>#" & processingdate & "#;"

[June7]

ranman, I like action queries in code.

I don't see anything else wrong with syntax. What is processingdate - a variable? Are you sure it gets populated?

Changing names would be easy with an add-in like Rick Fisher's Find and Replace - saved my sanity more than once.

[visidro]

Got it working changing the name ......

thank you for your help
cheers