Ask users for date range in a crosstab query

A

Adam

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

Thanks in advance.
 
T

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
 
Top