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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Date range by week on Report 5
Daily, Weekly, Monthly Totals 1
week (WW) conversion to date in Access Graph 2
Group Week Sunday to Saturday 5
Month Report with Weeks 5
Them delivery services - some good, some not so good 3
Date Format In A Report 2
How to Change start of week to Monday 1

Back
Top