Simple Software Solutions
My suggestion is that you create a crosstab query and the column heading are your week numbers (Group date by week number). I know that with crosstabs if there is no data present for a particular week number, in this instance, it will not display a column. However the trick is to go to the properties of the column and select column headings. In there enter 01,02,03,etc up to week 52 or whatever then when you run the crosstab query the column will appear even if there is no data for that period. You are infact forcing the column headings to appear.
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
The Home of Simple Software Solutions.
O/S Windows XP (SP3) & Windows 7 64bit
Access 2003 (version 11.0)
Access 2007 (version 12.0)
Remember when posting sample databases you will get a better response if it is pre Access 2007 - not all people have it installed.