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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Parameter Queries in Crosstab Query 2
Parameter Value in Crosstab Query 4
crosstab parameterized query 1
crosstab query with parameter query 5
Duplicate prompts in crosstab query and subsequent report 1
crosstab query parameters for dates 1
Help on crosstab query 2
crosstab query parameters 5

Back
Top