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.
Invalid bracketing of name [Between [Forms]![Start Date]![txtDate] And DateAdd("d",7,[Forms]![Start Date]![txtDate])]
Thank you for any assistance.