I am using Access 2000.  Can anyone tell me how to specify a criteria in a query that selects records from a "Yes/No" field that have an answer of "Yes" (or 1, or when one looks at the query, a box with a check in it)?
Regards,
Bob Brannon

Tell me if I have this straight.
Setting up a Lookup Column in a field to view the real value versus a record
ID is really best suited for the developer because of all the confusion with
extra relationships, right?

I have two tables..
The first contains contactIDno (autonumber) and other contact info. I would
like to add records to the second table containing mailshot details, by
copying a range of contactIDno's (specified by a query) and then adding other

Hi, I am using Access 2003 on a XP machine.  
I have a table with 73,000 records with 4 columns: ID (data type =
Autonumber), BIXS_Row_Code (data type = text), BIXS_Column_Code (data type =
text), Coefficient (data type = number).

Hi there, I am hoping someone can help with my calculation error:  I am
trying to convert a formula into a workable solution in Access but am not
getting the right results.  
the function is:  Min(TV *.1*.08, max(PrintCount-1.2(tv))*.08)

sometime ago we had notes on this, but are unable to locate them.  We have a
file with a lot of garbage in it.  All we want to do is select the records
that have email addresses only.
There is a way to setup the selection criteria in a "make table" query so

I have 4 separate tables of which all have fields "Surname", "Forename" and
"DOB", plus a data column.
Tbl_0 = S | F | DOB (this is all 5 users)
Tbl_1 = S | F | DOB | Data1

I have a query that uses a parameter on my form to update a combo box.  
My SQL:
SELECT DISTINCT [Phase]
FROM tblPhases

Quick question, is a UNION queries supposed to return unique values?
I have 2 tables, both with an [Invoice] field. When I generate an union
query between the 2 to get all the invoice #, I get a single row even if
a given invoice# is present in both tables.

i am trying to do an update of a table with an IIF() statement where if my
criteria is true the upade copies the previous record i cannot get the synatx
right for sendkeys it may that it is not possible?

Quick background...2 tables. 1 with all user information including Week1,
week2, week3 etc. (up to week 17).  Every week, i have to enter a value into
that specific week #, but I cannot use the same team twice throughout the 17
week period. The teams come from another table, ...

I am creating a query , say Query1 in which I am joining 2 queries, say
Query2 and Query3. I have joined them on a common field, say Field1. Values
of Field1 are such that the set of these values in Query2 is a subset of that
of Query1. I want Query1 to result only those records ...

I have a form that will be used by 20 users. It has about 50 controls. In
order to produce the correct criteria, I need to base it on a query of a
query (can't find any other way to get correct criteria).
The data becomes updateable if I turn on 'inconsistent updates' but this

i have a Database, which contains details of persons like Name, Age, Sex,
Address.
i want to make a query, in which, the query should ask for the min/max age
and then should display the details of persons whose age are above/below the

Sir/Ma'am,
   I currently have a query built to search for a text string in any part
of the field. The problem that I am running into was that when I use Like "*"
& [What is the name of the person you are looking for?] & "*", I get