The database contains a 'yes/no' check box.  I want to create a query that
will return only those records for which the box is not checked.  I can't
find any related information on the Microsoft website.

To all,
Happy Holidays.  
I have a query that I need to be able to find partial data in a text field.  
The data in the field looks like this:  SFC Doe, John M.  There are numerous

I have based a query on a table of client information.  The table is sorted
by unique client number, the query is supposed to be sorted by name.  The
query had been functioning well, but all of a sudden I get an error message
if any sort is applied that the record has been ...

I have a find duplicate query which selects matches on 3 fields.  How can I
add the ability to exclude matching pairs (or triplets, quadruplets, etc.)
which have all matching values in a 4th field?
Example:  select all records which have matches on invoice #, vendor #, and

I have an unbound date field that displays the date on a calender when the a
specific date is pressed. I am trying to develop a query to look up records
based on the date in the unbound field. I cant seem to get the query to come
back with any records even when a date is chosen ...

I have an update query that uses a date field in one table as the
update criteria for another table.  I want to be able to set the
criteria to use the last record entered in first table.  I've tried
putting 'last' Max etc but none work.

I've been doing simple joins and turning them into Delete queries for a long
while, but after taking a few months off and trying the same thing they've
stopped working.  While researching the problem I've found the "distinctrow"
issue described below.  My question is this:  When ...

Hi, I am using the Open Query Action in a macro and would like to browse for
the query name (to select the query to open) within the same DB.  Any
suggestions?

I have created a query that deletes blank records (i have controls that do
not allow blank entries on the web form, but somehow, i still get a ton of
them - robots, maybe?). However, I have to use it with the database open,
and then upload the corrected database to the server. I am ...

I have a database with student records and the classes they are enrolled
into. I have a query with the following SQL coding:
SELECT DISTINCT [Student in Courses].[Section ID], [Student in Courses].ID,
Courses.[Course Title], [Student in Courses].[First Name], [Student in

Can I output a series of tables or queries to the same excel file putting
each exported file into a new tab within the one excel file?

Dear Helpful users,
As a Newbie to ACC2000 I have created a dB for our Service Dept where we
record Customer details in one table and Repair details in another.
So far so good. I now want to create new records with a sequential number

Is there any way I can hide a query in the database window?

I can't figure out what I am doing wrong... I want the query criteria to be
defined by a combo box in the form. The user will select the criteria on the
combo box, then click a button to run the query, however the query keeps
coming up blank.

i have two tables([LIVE], [TEST]) each table contains two fields (mnemonic,
barcodes)
the mnemonics in each table match, but the LIVE table may have more barcodes
than in TEST.