Displaying YES/No Items in a Report

[Guest]

I have a table in which I have entered details of conference venues. I have a number of fields relating to different audio-visual equipment. For each venue I have selected YES/NO depending on whether a particular type of equipment is available

I would like to put this information into a report: I don't want the report to just show a checkbox with or without a tick for each record - I would prefer the report to ONLY display those items for which I have selected YES

For example: "The McGannaghan Suite" has a TV/Video, Whiteboard and OHP. It does not have a Blackboard or Telephone Point. Therefore, on the Report, I would like "The McGannaghan Suite" to display TV/Video, Whiteboard, OHP but NOT Blackboard, Telephone Point

I hope this makes sense, and would be very grateful if anyone could provide a solution (if it's possible!

Many, many thank

Jen

 

[Alp Bekisoglu]

Hi Jen,

Not sure how you want to display the result on the report so I'll just use a
wild guess and assume you want:
The McGannaghan Suite TV/Video, Whiteboard, OHP
Some Other Location TV/Video, Whiteboard, OHP, Blackboard, Telephone
Point
etc...
I guess you could make use of an unbound textbox in the detail section of
your report, next to, say, "LocationName" field and put this as its
ControlSource:
=IIf([tv_video]=True, "TV/Video ,","") & IIf([wht_brd]=True, "Whiteboard
,","") & IIf([ohp]=True, "OHP ,","") & IIf([bbrd]=True, "Blackboard ,","") &
IIf([tel_pnt]=True, "Telephone Point","")

The ones in [] are corresponding to your Yes/No fields. I have included the
comma within but you can carry it out as well. Then you'd need to use & ","
& in between the IIf's.

Hope it makes sense.

Alp

I have a table in which I have entered details of conference venues. I

have a number of fields relating to different audio-visual equipment. For
each venue I have selected YES/NO depending on whether a particular type of
equipment is available.

I would like to put this information into a report: I don't want the

report to just show a checkbox with or without a tick for each record - I
would prefer the report to ONLY display those items for which I have
selected YES.

For example: "The McGannaghan Suite" has a TV/Video, Whiteboard and OHP.

It does not have a Blackboard or Telephone Point. Therefore, on the Report,
I would like "The McGannaghan Suite" to display TV/Video, Whiteboard, OHP
but NOT Blackboard, Telephone Point.

I hope this makes sense, and would be very grateful if anyone could

provide a solution (if it's possible!)

 

[Jeff Boyce]

Jen

I may be reading too much into your description, but it sounds like your
table is structured something like:

RoomName
AV_TVVidio (Y/N)
AV_Whiteboard (Y/N)
...
AV_EquipmentTypeN (Y/N)

If so, this is ... a spreadsheet! Take a look at the topic of
normalization.

Another way to organize your data is to have three tables. One holds Rooms,
one holds AV_Equipment, and one hold the valid combinations of Room X
AV_Equipment. This third table helps you resolve the many-to-many
relationship you have between rooms and equipment. This third table will
have as many rows for, say, "The McGannaghan Suite" as it has AV_Equipment
items (in your example, 3).

A simple query joining the third table back to the first and second lets you
find all the equipment names for equipment associated with the room called
....

 

[Tom Lake]

I would like to put this information into a report: I don't want the
report to just show a checkbox with or without a tick for each record - I
would prefer the report to ONLY display those items for which I have
selected YES.

For example: "The McGannaghan Suite" has a TV/Video, Whiteboard and OHP.

It does not have a Blackboard or Telephone Point. Therefore, on the Report,
I would like "The McGannaghan Suite" to display TV/Video, Whiteboard, OHP
but NOT Blackboard, Telephone Point.

Make the Data Source for the TV/Video field be something like:

=Iif([TV],"Yes","")

and make the other fields be similar, substituting the name [TV] with the
names of the other fields.

Tom Lake