can a parameter be included in a crosstab query?

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

Tom Ellison

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
 
Top