Query to get All days per an extension Help please!

[plau011]

First thanks in advance for your help.

I am trying to do a query and am not sure if this is possible.

I have a table called Extensions:

ID Ext CDate
1 100 2/2/2005
2 101 2/3/2005
3 101 2/4/05

Then I have another table called DaysofMonth:

ID TheDay
127 2/1/2005
128 2/2/2005
129 2/3/2005
130 2/4/2005
131 2/5/2005
132 2/6/2005
133 2/7/2005
134 2/8/2005
135 2/9/2005
136 2/10/2005
137 2/11/2005

I would like to see 22 records 1 for each ext per day.
101 2/1
101 2/2
101 2/2
101 2/2 ...
101 2/11

102 2/1
102 2/2
102 2/2
102 2/2 ...
102 2/11

11 days per ext = 22 records

A cross join doesn't work because I would get 33 records. A outer
join on the date doesn't work either. I know there's got to be a way to
do this, but I can't think of one!!

Thanks

[plau011]

Let me update this actually. On the Extensions table I have:
ID Ext CDate Calls
1 100 2/2/2005 5
2 101 2/3/2005 3
3 101 2/4/05 7

So I want to see every extension per day with the number of calls on
that day. If they don't have any calls then show 0
Thanks

[AP]

My friend and I have done this in the past, and its not the prettiest
way to do it, but it seems to work. Otherwise we have written code if
it needs to be cleaner.

It is a 2 query approach.

Query 1
Add the days table and the calls table, without joining the two. Pull
the day field from the day table and the extension from the calls
table. Add grouping to the query so you get a list of unqiue
combinations. This should produce a record for each extension to each
day from the day table.
Query 2
Add query one and the calls table. Link with an outer join on the
extension and date fields. (Showing all records from the Query One and
only those from the calls table where the is a match)

This should work for you. You may want to add an additional expression
that handles the nulls and converts them to zero, something like this:
= IIf(IsNull([calls]),0,[calls])