Help Organizing a Report (I hate queries and i think they hate me too)

[rutkus]

Hey,

I'm working on a report that calculates three values (total #, total $ and avg process time). To do this ive set two crosstab queries to get the first two values and a select query to get the avg process time and link the other two queries. As i was doing this, i ran into hell.
For some reason the third query looks like this:

Vendor Month Apr Apr Aug Aug
Vendor 1 Apr $10 2 $15 1
Vendor 1 Aug $10 2 $15 1

what i was hoping to do was organize it so that when Apr was in the month column then only Apr amounts were filled into the cells. I'm not quite sure where im going wrong here...

but then i realized that i needed to take something else into consideration, years before and after 2001. So i decided to design a form that asks the user for beg and end date, but now i dont quite understand how to set it up as a parameter. I dont even know if im going about this right.

the report im designing needs to be setup like this, if theres an easier way of organizing it, id LOVE to know

Apr Aug Feb
Vendor 1
--total # 2 3 4
--total $ 10 15 20
--avg proc 5 4 3

if anyone could help, id really appreciate it.

If you need more detail just ask, ill be glad to explain

Thank you
Omar Qureshy
DSC Networks

 

[tempclerk]

Post your table setup and some sample data. It does seem like there should be a simpler way.