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.
 
Back
Top