Creating a crosstab parameter report

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

Guest

Is it possible to create a report based on a crosstab (plus parameter) query?
When I try this the initial report design view is continuously interrupted by
the parameter prompt.
 
You can use criteria from parameter prompts or from controls on forms. The
controls method is much more professional. You must specify the data types
of your parameters for queries displaying in a crosstab. This is done by
selecting Query->Parameters and entering something like:
Forms!frmDates!txtStartDate DateTime
Forms!frmDates!txtEndDate DateTime
 
The form must be open. If the form is open and the names are all correct,
you will not be prompted for the same.
 
Back
Top