Multi-tiered query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm drawing a blank here and need some assitance. I have a database of daily
activity. I have 75 seperate organizations reporting in the database. I now
want to write a query that averages each organizations monthly total from the
daily input, then outputs a report showing each organization and their 12
totals.

Can I do this with a crosstab query, or do I need to write something in VB?
I ask because I am much better designing a query than writing programming
code.

---Mike
 
You should be able to do this in a crosstab. However first create a query
that gathers up and sums all the data. Group on the date using the Month()
function. Then use this query as the basis for the crosstab.
 
Duh! - a query based on the results of another query. Some days simple things
just elude me.

Thanks for responding.

---Mike
 
Back
Top