crosstab query in access

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to run a crosstab query using a query with criteria as the
source. I keep getting an error message. Apparently the jet is confused by
the criteria parameter. What can I do to fix it?
 
You may be having the same problems that I had until I searched the newsgroup
and found my answer in many post.
Crosstab displays an error when you add criteria unless you define the
parameters.

Open the query in design view and click on menu VIEW - View SQL. The first
line should now start with TRANSFORM. You need to add like this before that
line --
PARAMETERS [enter beginning number] Text ( 255 ), [enter ending
number] Text ( 255 );

This example has two parameters but you could have one or more separating by
a comma and ending with a semicolon.
 
Back
Top