I want to be able to delete the second or multiple instance of duplicate
records in Access 2007.  The query wizard for duplicate records returns all
instances ....GREAT!  Oh I have 4500 records to trawl so a manual is out of
the question as approx 3300 of these are duplicated... ...

I have a table consisting of records of classes (date/time of lessons,
venue, book etc) and a related one for the teachers. There can be up to six
teachers to a class, minimum of one.
The problem I have is that of space: I have only two lines to show the names

I am sure this is not the optimal manner for doing what I want to do, but my
lack of skills has led me to this path.  Anyhow . . .
I have a query that has several records.  I desire to take this query and
create another that has but one record that contains all of the fields

If I were to look upinformations stored in a table using a query (thru a
form) to see if I have previously been to an address, can I have the system
ask me if I want to add a new entry or if the address is not found or have it
ask if I would like to new record if the address is ...

We use queries to extract data from our G/L. Our location numbers are stored
in 12 characters, 7 preceding hard spaces and 5 characters. In Access 2003
was able to use TRIM to get the 5 digit location using this in the query
select:

My database has two tables - Family and Children which are related showing
many children for one family.
I created a query to calculate School Year from each child's age.
I made a Family form with a Children subform which shows only the children

Hi,
I am trying to find a unique value in a string.  For example, the value in
my [ServiceDate] field is [1, 2, 3, 4, 5, 6, 11, 12, 21] and another has a
value of [2, 10, 12, 15], and I am trying to create a query that will state

i need a query that will display the values in the field but i do not want
the query to show duplicate values.

hi! maybe you guys could help me. i have two tables in msaccess, the first
table has two columns, the first column contains the names of columns in the
second table, and the second column has the "required values".
what I intend to do is compare the values from the second table ...

HELP Please... I am trying to build an IIf statement in my design view but
can't figure out how to get results compare to skill type.  I figure I am on
the wrong track.
I have the following Skills:

I am using Access 2003.  I have a form that lists states in a drop box.  
Depending on what state the user chooses, I need to be able to assign an
integer to another column for use in a formula.
example:

Is it possible to display query criteria on the report that is generated? For
example, the query requires the user to enter the start and end dates. Can
these start and end dates be somehow displayed?

In my query, I have a product code formatted as text, such as
"00013800055000".  I want to eliminate the first 3 digits.  Any suggestions
on a "MID" type function that will work for this?  I've tried a couple
different things, but have not hit upon the correct answer to this.   ...

I have two queries A,B.  Query B is a subset of Query A. Now I need a syntax  
to get Query A- Query B i.e., Query A without data of Query B
Can anyone help me on this.
I think its a pass through query if am not wrong

I have a query with two tables.
They are linked through an ID field.
My query is looking for dollar amounts that don't match between the tables.
Odd think is, a few of the values that show up as not being equal, really