CrossTab Queries

[Marvin Larson]

I want to prompt the enduser for a date range in running a
crosstab query. Not a problem with a 'select' query, just
a crosstab query. Any suggestions?

 

[Tom Ellison]

Dear Marvin:

With any query that has parameters, you can declare them. In a
crosstab that has parameters, the declaration is required.

Tom Ellison
Microsoft Access MVP
Ellison Enterprises - Your One Stop IT Experts

 

['69 Camaro]

Hi, Marvin.

You may be interested in Tom Wickerath's step-by-step tutorial on crosstab
queries. His tutorial even provides guidance on how to avoid common errors.
Check out step #15, which will show you exactly what you need to do to
prompt the user for a date range:

http://www.Access.QBuilt.com/html/crosstab_queries.html

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.