How to force empty report dates to show

M

MR. S

I have a report that shows for instance sales for each day. The user selects
a date range and clicks to view the reports. The problem is that iif a
particular day does not have any sales it does not show up in the list of
reports generated. The user would like to see each day and be able to click
through them with the record selector in the bottom of the screen. The user
would like to see a day even if it has no sales, ie a day with no slaes would
be a blank page with just the date on top.

How can I do this?

Thanks
 
R

Roger

Your going to have to create a matrix with all the dates first then populate
it with the data for each corresponding dates. Then build a report off the
matrix.

1. Create a make table query with the dates. Remember to make a filed for
the sales data as well but you will leave that blank for now.
2. Create a update query and update the temp table with the sales data.
3. You can now build the report off the temp table.

RH
 
V

Van T. Dinh

You will need to create a tblDate with one Record for each working day
concerned.

You will then need to create a Query with the Left Outer Join Table from the
tblDates to the tblSales. This will create a "no sales" row for each date
with no sales.

Base your Report on this Query rather than the tblSales.
 
Top