View Single Post
  #1  
Old May 27th, 2010, 09:52 PM posted to microsoft.public.access.reports
Derfel
external usenet poster
 
Posts: 8
Default Using select and crosstab queries on one report

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?