Creating a crosstab parameter report

G

George R

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.
 
D

Duane Hookom

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
 
D

Duane Hookom

The form must be open. If the form is open and the names are all correct,
you will not be prompted for the same.
 
Top