Query Problem

[DreamOn]

well im kinda new at this stuff, so you might have to bare with me.

so i have a table which i need to gather information off with a query, some of the information is in Yes/No boxes and other is in a drop down field..

here is a list of fields i have..

Referrer - Drop Down List

16/17 - Yes/No Box
Newsletter - Yes/No Box
Insurance - Yes/No Box

i have others but we will use these as an example..

so in my query i have the first name, last name, address

but i need to find out people who are from a certain referrer but also a certain yes/no box..

e.g

Referrer - Carer
16/17 - No
Newsletter - Yes
Insurance No

how can i get the query to show all the people who are referred by the carer and also receiving newsletter..

the referrer field i have.. [Enter Referrer] but then i dont know how to select 16/17, Newsletter, Insurance..

any ideas?

 

[Uncle Gizmo]

If I understand your question correctly, then you have several fields holding yes/no data (Boolean)

the following being three separate fields:
16/17 - Yes/No Box
Newsletter - Yes/No Box
Insurance - Yes/No Box

If that's the case then you need to transfer the information from the above three fields into a new table and relate it to the original table.

Once you have done this you will find that creating queries from the data is a simple matter.

There are comprehensive instructions and a free tool to make this an easy task available here: