I’ve set up a simple database in Access 2003.
It has one table with 5 fields. 1 Primary index autonumber, 1 Date field and 3 fields filled from lookup tables.
I want a report that will count records in this one table and specifically for the different values of one of the fields whose three values are in a lookup table.
There are several situations when the no of records for a particular value is ZERO. I still want an entry in my report, stating that the number of records with that field value is ZERO.
Clearly as their are no records they are not counted and not included in the report.
I have tried various searches and tech sites but cannot find the answer.
Any suggestions?