Access Report with dates

[Fernando Sanchez via AccessMonster.com]

Hi,
I have a report to track shipments.
Because we don't ship every day I have no data for those dates in which no
shipping took place and my report looks like:


Date Shipped
1/1/2005 100
1/3/2005 25
-------
Total 125



What I would like to do is display ALL dates, including those with zero
shipped:


Date Shipped
1/1/2005 100
1/2/2005 0
1/3/2005 25

 

[Duane Hookom]

You might need to create a table/query with every possible date. You can
then use a join to this table that includes every record from the table of
dates.