I have allowed a database to use duplicate IDs
I need to set up a query to omit all the instances of duplicate IDs
can anyone help please?

Please can anyone help?
Right then, I have a table with students records that tracks name, address,
teacher, etc....
I want to be able to create a query that lists 20% of each Teachers current  

In a Make Table Query, how can I have the fields in the new table be
different from the field name in the source table? For example - Expr1 in the
source table should be Name in the destination (new) table.

I have posted a couple of posts previously,but am still not getting the
result I need.
I want to produce a report of staff qualifications and to count how many
staff are qualified. However some staff have more than one qualification, but

Hey does anyone know how to get the say top 1 by id with the hightest date,
for example:
date      name  id
22/11/5 anna  1

Each week, I need to take about 30 queries from access, and export them
to Excel. I then need to format the excel spreadsheets and email them
to various people.
I would like to automate this process so that I can just click a button

I have designed an append query originating from 4 diffrent tables, and have
set the Group By for two fields to last. However, this does not work, and
when I run the query, I do not get the last record. Here follows the query in
SQL view:

If someone could help me I would greatly appreicate it.  Here's the problem:
I run a monthly report which by using criteria on my file # field gives me a
list of that month's files.  I also have criteria in to keep it from pulling
files that were on HOLD for that month.

--------------------------------------------------------------------------------
What is the syntax for creating a Decimal field using the CREATE TABL
statement? For example, this works for a Double field:
Currentdb.Execute "CREATE TABLE aTable1 (f1 DOUBLE)"

I'm using the following formula in a query to calculate the number of months
left on a lease based on a set end date and todays date:
MonthsLeft: DateDiff("m",Now(),[EndDate])
I dont want it to display negative numbers though for leases that have

I have a query that displays OrderQuantity and CostPerUnit. I want to group
the data in the query so I can see the average CostPerUnit for interval
ranges of OrderQuantity; For example:
Ordersize                 CostPerUnit

I want to be able to format the date for my query that asks a user to enter a
date. The date is stored a date/time field. I want my users to only enter the
date and not the time. The data is  captured and stored as a date/time field
in the database table. Here is my user prompt. ...

Hi i want a select statement that will choose distinct and not distinct. i
have a select statement with 10 field that is distinct  select and i want the
11 field to not be distinct select. how do i write the select statement. in
one query. thanks!

I presently have a DAO routine that creates recordsets so I can scroll
through and find different or missing values between the recordsets.
I felt I could have the most control with this setup.
However, after being recently exposed to some powerful SQL (see More help

Made a query that runs when I run a report. Query has one field call Field 1
and one called Field 2.
Field 1 could be 8, 9, or 10.
Field 2 could be 1, 2, or 4.