Re: Reporting null values or blank sheets
- From: John Spencer MVP <spencer@xxxxxxxxx>
- Date: Tue, 30 Jun 2009 09:52:53 -0400
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.
- References:
- Reporting null values or blank sheets
- From: david
- Reporting null values or blank sheets
- Prev by Date: Reporting null values or blank sheets
- Next by Date: RE: search date
- Previous by thread: Reporting null values or blank sheets
- Index(es):
Relevant Pages
|
