How do I create a filter to return counts

C

CeeBeeSky

I have sales data that I would like to create a report on. This report would
count the number of events based upon the total and seperate them by year.
In Excel it looks like this:


2003 2004 2005 2006 2007
$0 - $1,000 134 98 69 40 7
$1,000 - $5,000 212 152 147 120 17
$5,000 - $15,000 73 94 94 92 20
$15,000 - $25,000 17 18 24 27 1
$25,000 - $50,000 8 15 22 16 0
$50,000 + 2 7 7 9 1

I can create seperate queries to give me the dollar value of one line by
years but cannot seem to figure out how to get all of the above detail on one
report. Is this possible?
 
D

Duane Hookom

This looks like a basic crosstab query. Is the "$0 - $1,000" a value in a
table? Do you have a table of dollar ranges?
Can you share your significant table structures?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top