Need Report to show all days-even inactive.

[froggiebeckie]

Greetings:
I'm trying to replace a huge, ugly,hard to manage Excel spreadsheet with a data base.--save a lot of sweat, tears and foul language and virtually eliminate errors caused by re-entering figures several times. Great Plan, right?
Problem is, I'm stumped.
So far, I've got:
Make table queries that pull data from a separate, pre-existing db, based on a specified date range.
A Date Range form that let's me only enter the date one time to drive all queries.
The start of several reports to show activity for each machine (within this date range), based on product type.

The problem is:
Each machine is capable of making several types of product, so on any given day, some of the "Product Type" reports will have several machines with no activity to report. Right now, those days with no activity are just not listed. If none of a particular product was run on any machine within the date range, I get error messages.
How can I show ALL DAYS within the date range, with "0", if there is no activity?

REPORTS NEEDS TO LOOK SOMETHING LIKE THIS:
"TYPE A PRODUCT"
DATE ------- MACHINE A ------MACHINE B -----MACHINE C
2-2-04--------- 30---------------10------------- 50
2-3-04----------0---------------- 0 -------------0
2-4-04 ----------0--------------- 25-------------0

or

"TYPE B PRODUCT"
DATE ------- MACHINE A ------MACHINE B -----MACHINE C
2-2-04--------- 0-----------------0------------- 0
2-3-04----------0---------------- 0 -------------0
2-4-04 ---------0----------------- 0-------------0


Thanks in advance,
Beckie

 

[WayneRyan]

Beckie,

It's not clear as to whether:

Data records are there - but have null value(s), or
Data records are not there for some dates.

Wayne

 

[froggiebeckie]

Sorry, forgot to say:
If no activity, then there are no data records. Need to know how to create them, I guess.