Access Invalid bracketing of parameter name

Joined
Jan 11, 2018
Messages
1
Reaction score
0
I am trying to pass a parameter from a form to a query. I have used the wizard function, so the bracketing was created by the wizard.
SELECT Input_GENERAL.[Name], Input_GENERAL.[AP]
FROM Input_GENERAL
WHERE (((Input_GENERAL.[AP])<[Forms]![frm_RunReport]![txt.RptEndDt]));

When I run the query, I get the error Invalid bracketing of name [Forms]![frm_RunReport]![txt.RptEndDt]. I cannot understand how this is happening when the syntax was created by the wizard. The fields AP and the parameter txt.RptEndDt are both short date.
 
Joined
Mar 14, 2018
Messages
5
Reaction score
0
Is your field name really called txt.RptEndDt. The problem is the period in your field name. Field names should never have a period in them. The wizard puts in brackets around field names in case you field name has a space in it, if it doesn't you don't need the brackets.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top