How do I select a range of transaction dates in a crosstab query

[Guest]

I want to select dates within a particular range that varies each time from
my crosstab query. My query returns all the data each time regardless of what
parameters I put in.

 

[Allen Browne]

You must explicity declare your parameters in a crosstab query (unless you
specify column headings.)

1. In query design view, choose Parameters on the Query menu.
Enter 2 rows in the dialog:
StartDate Date
EndDate Date
Close the dialog.

2. Add your date field to the query grid (again if you already have it
there.)
In the Total row under this field, choose:
Where
In the Criteria row, enter:
Between [StartDate] And [EndDate]