Crosstab parameter help

  • Thread starter Thread starter 2
  • Start date Start date
2

2

Hi,

I have read that to do a crosstab query using parameters I have to
explicitly declare them.... how exactly do i do that? I am trying to
reference start and end date fields on a dialog form....


Cheers
 
Open your query in design view and select the Query menu... at the bottom is
Parameters... click this then add the form control that has the data as the
parameter name and finally select the datatype...
 
Hi,

I have read that to do a crosstab query using parameters I have to
explicitly declare them.... how exactly do i do that? I am trying to
reference start and end date fields on a dialog form....
Click to expand...

Right mouseclick the background of the tables in the query design
grid; choose Parameters from the dropdown list. Or, there's a menu
option, I think it's View... Parameters.

In either case, copy and paste the parameters from the Criteria line
into the left column of the parameters window (they must match
EXACTLY) and specify that they are of date/time type in the right
column, using the dropdown.
 
Back
Top