Prev: Entering Report Parameters through a Form
Next: A Great Big Thank You!
From: derfel on 27 May 2010 16:52
I created a report based on a crosstab query which shows a count of items by
therapeutic category (row field) and month (column field). So far so good.
Now I want to add in a column on my report which uses a select query to count
"unreviewed" items in each therapeutic category (ignoring month). So far I
have been unable to figure out how to get this total to show in my report. Is
it possible to use both queries on the same report? Or do I need to rethink
my crosstab query?

From: KARL DEWEY on 27 May 2010 17:09
Post the SQL of both queries and what signifies that item is "unreviewed".

--
Build a little, test a little.


"derfel" wrote:

> I created a report based on a crosstab query which shows a count of items by
> therapeutic category (row field) and month (column field). So far so good.
> Now I want to add in a column on my report which uses a select query to count
> "unreviewed" items in each therapeutic category (ignoring month). So far I
> have been unable to figure out how to get this total to show in my report. Is
> it possible to use both queries on the same report? Or do I need to rethink
> my crosstab query?
>
 | 
Pages: 1
Prev: Entering Report Parameters through a Form
Next: A Great Big Thank You!