Using select and crosstab queries on one report
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?
|