[AccessD] Grouping Query

Actually, it's a join beteen *four* crosstab queries.

Charlotte Foust

-----Original Message-----
From: Tim Thiessen [mailto:tim at irwingreenhouses.com] 
Sent: Thursday, January 15, 2004 1:30 PM
To: accessD at databaseadvisors.com
Subject: [AccessD] Grouping Query


Hi Group,

I have a query that returns the following:

PaymentTerms		DatePaid	CountOfPaid
COD			1			5
COD			2			3
COD			4			8
COD			14			4
COD			16			12
Net 10-EOM		1			3
Net 10-EOM		3			10
Net 10-EOM		5			15
Net 10-EOM		10			21

DatePaid is the day of the month in which payments are made.
CountOfPaid is a count of the number of payments made on particular
date.  What I need to do is to be able to group this data into the
following:

PaymentTerms		Paid1-6		Paid7-13	Paid14-20
Paid21-27	Paid28-31
COD			16		16		0
0		0
Net10-EOM		28		21		0
0		0

I know this is a cross tab query but how do I get the grouping in the
first place?

Tim Thiessen

_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com