Using select and crosstab queries on one report

  • Thread starter Thread starter derfel
  • Start date Start date
D

derfel

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