can a parameter be included in a crosstab query?

  • Thread starter Thread starter coljam2468
  • Start date Start date
C

coljam2468

Hi, I'm trying to create a crosstab query that I can enter the dates,
but there dose't seem to be a function (newbie) for this.
What I'm currently doing is, using a crosstab query against another
query. Surely this can't be the way it's done?

Thansk in advance.
 
Dear Col:

In a cross-tab query, parameters must be declared. In other queryies, this
is usually optional.

Right click in the Design View's upper area where there are not tables
showing. Choose "Parameters" and list them, with their datatype.

Tom Ellison
 
Back
Top