Simple Group By Query w a placeholder record?

[murfeezlaw]

I'm running a Group By Query to get totals by Tier. If i have 4 records...3 have a value of 3 in the Tier field and 1 has a value of 2 in the Tier field I will get the following result from a Group By query for example

Tier	Discount	Rooms	Units	CUWODO	CUWDO	2FAM	18H	COMM_OFF	WH	VAC
2	20	188	14	14	14	14	14	14	14	14
3	20	511	30	24	24	54	26	28	12	22

I want to see this if there are no records under Tier 1.

Tier	Discount	Rooms	Units	CUWODO	CUWDO	2FAM	18H	COMM_OFF	WH	VAC
1	0	0	0	0	0	0	0	0	0	0
2	20	188	14	14	14	14	14	14	14	14
3	20	511	30	24	24	54	26	28	12	22

Can anyone give me an idea how to do this? Is there a way to create a "dummy" record place holder for Tier 1 and give all 0s? Any help would be very much appreciated. I'm trying to find a way to do this but i'm not even sure how to look up help because i don't know how to describe what i'm trying to do.
TIA
Ted

[Rod]

Build a table with one record for each possible Tier. Join this table to your existing aggregate query on the tier fields. Group on the tier values from the new table.

[murfeezlaw]

Ugghhh why didn't i think of that? Great idea and it worked like a charm. Thank you for your help!