Missing Months - select query not crosstab.

[r0nniem]

Hi there,

I've been searching around here for sometime on this topic with no luck.

Here's my data:

Year Month No Month Tech ALL Not COMP COMP %_COMP
2005 8 Aug 2005 Weipa 3 0 3 100.00%
2005 9 Sep 2005 Weipa 1 0 1 100.00%
2005 10 Oct 2005 Weipa 1 0 1 100.00%
2006 1 Jan 2006 Weipa 1 0 1 100.00%
2006 2 Feb 2006 Weipa 1 0 1 100.00%
2006 3 Mar 2006 Weipa 1 0 1 100.00%
2006 6 Jun 2006 Weipa 1 0 1 100.00%

How would you suggest I fill in the missing months and years? Is their a function I can write for this based on the form's date range?

 

[ZmrAbdulla]

I am not sure what the gurus suggest.. but I'd go for a new table that lists all the months and make a join with this query.

________________________________________________________
Zameer Abdulla
Help to find Missing people
Sharp acids corrode their own containers.