Crosstab query error

opostal

Registered User.
Local time
Yesterday, 20:15
Joined
Jun 26, 2009
Messages
47
I have a parameter query which returns me the data I need with two input parameters, a name and a date. The query provides the correct data but I need the output to be in a crosstab query so I created another crosstab query to make this happen off of the existing parameter query. The problem lies in that the crosstab query returns an error due to bracketing. I have gone into the parameter table and set the parameters for these two items and still receive bracketing returns. Here is the where I am at now:

Invalid bracketing of name [Between [Forms]![Start Date]![txtDate] And DateAdd("d",7,[Forms]![Start Date]![txtDate])]

Thank you for any assistance.
 
I have made several other attempts but no luck as of yet. Thanks in advance.
 

Users who are viewing this thread

Back
Top Bottom