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

Similar Threads

Calculating totals on a Crosstab Query 33
How to create this report 1
Rearrange numbers from a column in a different order in a second c 14
How do i create a report to be used as a form to track attendance? 3
How do I create ranges/groups in excel in a pivot table? 2
Need a query to return a value if out of range 4
VLOOKUP with LARGE 8
Trouble figuring out how to Loop through a huge repetitive macro 12

Top