Access Invalid bracketing of parameter name

S

Steffa67

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.
 
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.
 
Back
Top