How do I group data by weeks and get it to report 0 for a week?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

The data that I am retreiving is daily deliveries. I am grouping it by week,
but if no deliveries came from a given supplier that week, it just skips the
week. How do I make display that week with no data and use the IsNull
command to display a 0?
 
The general method is to create a table/query with all potential weeks. Join
this query to your report's record source query with a join type that
includes all records from the "all potential weeks" query.
 
Back
Top