Design Query with date ranges as columns?

wchelly

Registered User.
Local time
Today, 15:11
Joined
Mar 1, 2010
Messages
146
Is there a way to design a query so that the column names are January, February, etc, and include anything delivered in that month?

And then have the Rows total the number of records for each product type for each month?
 
That sounds like a perfect way to use a crosstab query. I can't help you do specifics but it might help to research that!!
 
A cross tab query worked perfectly. It creates a column for each month in which products were shipped. Is there a way to dynamically create columns for months where no products shipped? The problem is that since there are no shipments in there for those months (yet), it does not create a column for that month. Therefore, to try to create a running total does not work unless all the months exist.
 
I've tried a crosstab query for what I'm trying to accomplish (months in columns also) but so far the results are less than promising. I'm still trying to figure this out :-)
 
I have the months as columns figured out, but what I can't figure out is how to get another row below the column totals that gives a running total for the year for each product type each month.

If you need help with the months as columns issue without the other issue, let me know and I can probably help.
 
I've got another thread started where I'm getting some great support, so I'll wait to see what comes out of that. Don't need to have too many people chasing my problems :-) But thanks!!

David...
 

Users who are viewing this thread

Back
Top Bottom