Re: Reporting null values or blank sheets

Tech-Archive recommends: Fix windows errors by optimizing your registry


Do you have a table that shows just the rooms and information about the rooms? You should have. If you do, you need to add that to your query and join it to the table that shows the equipment in each room. If you don't have a table listing just the rooms and information on the room, you need to create one.

Your table might look something like the following
tblRooms (with something like the following fields)
RoomID
RoomNumber
FloorNumber
Capacity (Single, Double, Multi-bed)
Window
RoomType: (Store Room, Patient Treatment area, Patient, etc.


You would click on the line joining the two tables and select option 2 or 3 - whichever one says something like ALL records in the Rooms table and only matching records in the equipment table.



John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County

david wrote:
Hi

I have created some reports to show equipment within rooms of a hospital project, and all is working as I would like, apart from the rooms with no equipment in are not reporting.

Am I right in assuming this is because they are 'null' values (sorry for my limited knowledge of null values).

I would like these rooms to report, with the text 'No Equipment Within Room'.

Can anyone please advise on how I go about this.
.

Quantcast