Please help...
I am using access to gather information. Such as.. I need patient's with a
zero balance on there account. I have a used a query to return this
information however I have duplciates for every entry where the patient has a

Is it possible to have parameter query that uses multiple values?
Example: a large database contains a field named "ClassCode".  The user
wants to specify any number of values for this field (like "JSB", "JSC",
"JGS") or retrieve all records.

Is there a bug in Access 2007? I have constructed a UNION query with 5 parts,
selecting the same number of fields from a table but with different rows
based on different criteria, as follows:
SELECT col1, col2, col3...col5 AS [common name1], col6 AS [common name2]

I have two queries, [qry changed basics] and [qry normal lines compare].
Each query includes the field [person] (which is a key field in table
[persons].) I need a query that will return all records from [qry changed
basics] and [qry normal lines compare]. At the moment my 'select' ...

I am using two multi-select listboxes. I use one saved query that refers to
another saved query, but I am just curious if there is a way to turn this
into a single SQL statement? I mostly only use the query design grid...
Query 1:

I have a list of 1000 records with only 1/3 unique.  The table looks like this:
name               recordID            date
kim                  000111              1/2/08
kim                  000111              2/9/08

using access 2007, however, I found it strange that I couldn’t find the
option Query while opening access 2003 database file with access 2007. I am
wondering whether access 203 database file is compatible in access 2007. Also
do I need to convert access 2003 files into access ...

I have two queries, qryPatients and qryCharges.  I have a main form bound to
qryPatients that has a subform bound to qryCharges.  How would I make each
new charge squence with a number.  To better explain, if I am looking at
Patient Jane Doe and I add the first charge, it would ...

In our homeowners association, we have a directory and some of the folks do
not want some of their personal data to appear in our directory.  So among
many other fields in my database, I have fields in my table/query and I want
to show records in text field1 based on the results ...

I'm using Access 2003.
I have the following table (example) -
Ln   Class      Price
01   10001      10

I want to develop a form that has a command button which will open a
parameter query. The parameter is a date field. There are 3 dates:
"ScreeningDate", "ICFDate", and "D1Tx", each of which is drawn from a table.
I need to be able to open the query if any of those 3 fields are ...

I have two tables in my database, CH2_1 and CH2_2. They both have identical
variables - Quarter, Purchaser, Provider, O_D, WAIT02, WAIT35.
However, they have different values in the WAIT02,WAIT35 variables. Both
tables have some cases with the same quarter,purchaser etc, bt table ...

I am working on a query that sums 2 fields separately.  I created an
expression to calculate a percentage based on these 2 sums - sum of column 2
/ sum of column 1.  I set the format to percentage.  The sums and calculation
of the percent work fine.  I now need to tell the query to ...

I would like to create a prompt query where the user can type the information
in a text box and then select what column they would like to search and
output the unique ID. For example. You may want to search for a serial number
in the S/N field of the main table and the output ...

I have 2 tables tempBrand_Work_Table & Brand_Work_Table.  I trying to run a
query to find the BrandID's that are "NOT LIKE" in the orginal table.  
BrandID is a text field.  I even tryed <> with the same results.  
I can't get the resolutes I looking for with the following SQL: