Show all days in a selected date range

  • Thread starter Thread starter M
  • Start date Start date
M

M

I have a query that returns results based on a 'Between'
date range. I need to show not only the Mon-Fri dates, but
the weekend dates as well. However there are no records
for the weekends (no business done on weekends). How would
I show these weekend days regardless of their not having
records?

Ex.---

[Date] | [Amount]
03/04 10.00
03/05 20.00
03/08 30.00
03/09 40.00

The two days -- 03/06 & 03/07 -- do not show because there
were no sales. I have tried Is Null but there aren't any
records to begin with. How do I get them to show?

Thanks

M
 
The only way I'm aware of is to create a table that has one row for each day
of interest, and do a Left Join between that table and your query.
 
Back
Top