I am trying to run a report that shows all the records in my database, even the ones with blank values. When I run the report now, I am only seeing the records that have values in every field i have included in the report. How do I setup the report to show all my records, even the ones with null values in some fields. Thanks!
Having records with null values show in report
- Thread starter mmmk
- Start date
Kryst51
Singin' in the Hou. Rain
- Local time
- Today, 11:58
- Joined
- Jun 29, 2009
- Messages
- 1,896
It involves the way the tables in the queries are linked. In the QBE, double click on the linke between your tables, and there should be three choices, pick the one that says "show all tables from...." that talks about the table you want "ALL" records to be shown.....then click OK and then save.
Attachments
Similar threads
Solved
Filter Report
