Crosstab query using form criteria - invalid bracketing

[AndyK]

Hi



Despite googling this and trying a few things, this is still driving me crazy!

I have a cross tab query which is querying data based on a range of dates.
If the query uses a popup each time (i.e [Enter start date] etc) the query works fine.

However, what I want to be able to do is to take the date range from two calendar controls in a form.

Problem is I keep getting "Invalid bracketing of '[Forms!]![frmMain]![byTeamStartDate]'".

I read yesterday that the parameters need to be declared in crosstab queries. This I duly did and both are set as date/time formats

[Forms!]![frmMain]![byTeamStartDate]

and

Forms]![frmMain]![byTeamEndDate]

but the query still doesn't like it and thus I am tearing my hair out (as the majority of the rest of the database's queries will be similar).

Grateful for any help!
Thanks

Andy

[pbaldy]

Take out the red exclamation mark:

[Forms!]![frmMain]![byTeamStartDate]

[AndyK]

Paul - thanks so much. Annoyed with myself I didn't spot that!
Query working fine now

thanks again

[pbaldy]

No problemo. I think it's human nature that once you miss something like that, your eye will continue to see it wrong no matter how long you stare at it. Happens to me all the time.