Ask users for date range in a crosstab query

[Guest]

How do I ask users to enter a "start date" and an "end date" in a crosstab
query?

Thanks in advance.

 

[Tom Ellison]

Dear Adam:

You can add parameters to a crosstab like [StartDate] and [EndDate] by just
typing those in. They can be columns and/or criteria. As long as these
terms are not existing column names that should do it.

In a crosstab, it is required that you declare those parameters. In most
other query types, declaring them is optional.

Tom Ellison