Listing record counts as zero in reports

T

Tciprop

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?
 

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

Count funtion in report-I'm too rusty! 1
trying to sum a group of records but "sum" missing from Group, Sort, and Total dropdown/wizard 8
Saving page number from report 5
Return Desired Value in a Text Box 4
Counting Records in a Report 8
Report made of a query cross table 5
Display all records from table regardless of relationship 6
How to count records using count(*) in a chart report 3

Top