Trouble with Crosstab Query

[cbende2]

Hello all,



I have a crosstab query built on a select query.

It works perfect. However, when I try to use the "Between [BegDate] And [EndDate]" it tells me access engine can not recognize it.

If I use this in the actual select query it works fine. But when I try to use the crosstab query it gives me the above error.

Also, I'm using two undbound textboxes on a form for [BegDate] and [EndDate]. I have the syntax correct in my select query and it works fine. But it won't work with the crosstab query.


Anyone experienced this problem before?

Thanks

[June7]

Filter criteria in CROSSTAB is different from other queries. Review http://allenbrowne.com/ser-67.html#Param

[ranman256]

in a crosstab query YOU MUST DEFINE PARAMETERS in the select query.
normally you dont need the paramerters in a select query, but CROSSTAB demands it.
so in the select query, parameters icon on the toolbar,
put the textboxes
forms!frmMain!txtBox1 , as date

etc.
THEN IT WORKS!

[cbende2]

How does it know which field I am referencing for the date range?

One of my fields is FeeReceivedDate, I want the date range to be based on this field.


EDIT:

Figured it out, I had to leave the original criteria in my select query, I had removed that.


Thanks guys