crosstab query

  • Thread starter Thread starter chris morrison
  • Start date Start date
C

chris morrison

I am trying to run a crosstab query based on the answer of
a query that has a select statement in the criteria for a
date range. The crosstab query says it doesn't recognize
the select statement in the underlining query. What gives?
I know the select statement works in the original query, I
use it all the time.

Also, how do you get percent totals in a crosstab query?
Thanks, Chris Morrison
 
You must specify the data type of all parameters in Crosstab Queries. Select
Query|Parameters and enter your exact parameters and select their data
types.
 
Duane Hookom answered your first query.

The second question is that you probably don't do it in the query, but do it as
a calculated control on a form or report.

If you need to do this in the query, could you expand on what you mean by
percent totals and post the SQL statement that you currently have.
 

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 Value in Crosstab Query 4
Make-table query with around 2 ml records taking too long 0
crosstab parameterized query 1
dcount in a crosstab query 3
Crosstab query error 1
Parameter Queries in Crosstab Query 2
crosstab query parameters for dates 1
Insert a crosstab to temp table 4

Back
Top