Show Field in query if Check box = Yes

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Mike B - 27 Jul 2006 01:57 GMT

I have set up a form for a Bus timetable which has a selection for Day and
Locations which uses a Check Box method, i.e if you want a trip on a monday
select yes and which time points did you want listed. The trouble i am having
is the fields that are not selected are still showing in the query.

How can i get the query to only show fields that are selected through the
Check box.

Reply to this Message

Duane Hookom - 27 Jul 2006 02:42 GMT

It really sounds like you have a normalization issue. However, you haven't
provided much information about your tables, fields, form(s), or anything
else. Can you provide some sample records and what you would like to display
in a form or report?

Signature

Duane Hookom
MS Access MVP

>I have set up a form for a Bus timetable which has a selection for Day and
> Locations which uses a Check Box method, i.e if you want a trip on a
[quoted text clipped - 5 lines]
> How can i get the query to only show fields that are selected through the
> Check box.

Reply to this Message

Mike B - 27 Jul 2006 02:58 GMT

DayType Mildura SwanHill Bendigo Melbourne - these are fields
Monday 9:00 10:00 12:00 13:30
Tuesday 9:00 10:00 12:00 13:30

The above is in a table called tbl TimeTable, the form is based on check
boxes (yes\no) and the information is saved in tbl SelectedTimeTable. The
query uses tbl TimeTable and under each field is a IIF statement ie IIf([tbl
Select TimepointsUp]![Monday]=Yes,"Monday"). This works fine for the field
Daytype and shows the Time Table information. The problem that i have is that
i do not know how to only show the timepoints selected. If the person only
selects Mildura and Melbourne for Time table information i do not want
SwanHill or Bendigo showing.

Cheers
Mike

> It really sounds like you have a normalization issue. However, you haven't
> provided much information about your tables, fields, form(s), or anything
[quoted text clipped - 10 lines]
> > How can i get the query to only show fields that are selected through the
> > Check box.

Reply to this Message

Duane Hookom - 27 Jul 2006 03:32 GMT

I would create a timetable with records like
DayNum Stop StopTime
1 Mildura 9:00
1 SwanHill 10:00
1 Bendigo 12:00
...
2 Melbourne 13:30
You can then query the specific records you need.

Signature

Duane Hookom
MS Access MVP

> DayType Mildura SwanHill Bendigo Melbourne - these are fields
> Monday 9:00 10:00 12:00 13:30
[quoted text clipped - 32 lines]
>> > the
>> > Check box.

Reply to this Message