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.
 

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

Similar Threads

Outlook Creating an Outlook form 2
ACCESS - how do I apply a IIF = statement without parameter value prompt. The two column comparison is count 1
Access 2003 Access Error Form Name 0
Access Create option group without using wizard? 2
Access How to Validate the query parameter before loading the form that is based on the query iteself? 2
Access Field won't show as currency in the form, shows just a number (but works fine in the query) 1
Access Control on subform / combo box requesting parameter 0
"invalid bracketing of name" when referencing Query Parameter 7

Back
Top