Ask users for date range in a crosstab query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

Thanks in advance.
 
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
 
Back
Top