Multi-tiered query

[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

 

[Guest]

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.

 

[Guest]

Duh! - a query based on the results of another query. Some days simple things
just elude me.

Thanks for responding.

---Mike

 

[croy]

Duh! [...] Some days simple things just elude me.

You're probably preaching to the chior, in this group!

Certainly anywhere near this keyboard.