best way to add 'filler' data 1

[psimon88]

Hello

I have a report that pulls information based on dates. Sales by date is pretty simple.

7/1/05 6,000
7/5/05 8,000

What's the best way for me to include 'filler' values of 7/2/05 (etc.) without further complicating an already complex set of actions to populate tables (many action queries, to make a long story short).

I suppose that I can create a big, 365-date table and pull only those filler dates if there's no 'real' data in the fields. I didn't know if there was a simpler calculcation or some VB code that would do the trick as well.

Thanks.

 

[dhookom]

A 365 record table is not overly big. This is probably the method that I would use. YOu can modify the join between the tables to include all the records from your dates table.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]