Can I add a simple statement to a query to eliminate duplicates, without
having to create a new query without making a new "Find Duplicates Query".
example:  Criteria = "no dups"

Where can find the syntax on Create Table...?
I need to use Create Table... statement to create a access table with an
Autonumber column as PK.
Thanks!

have a large database of students. The system should create a a new field
"Assigned" to assign the students, numers to a certain maximum, say 5.
The first 5 on the list will asume 1, 2, 3, 4, 5
The next 5 will assume 6, 7, 8, 9, 10

I am running into a problem with doing a simple query on a date/time
field in a MSA 2000 database.  I have googled around but for some
reason I can't get a generic answer in regards to the formatting of a
date/time query.

Ok folks I'm stumped!
I have seen this before, but for the life of me can't remember how to do it.
I have a safety and health database with a body part query.  Within that
query is a column that has numerous body parts listed.  I need to be able to

Hi,
I have an 11 table Database all relating to "Student Information" SSN
(primary key).  The rest of the tables have SSN also, but they don't have a
primary key field in any of those tables.  When I create a multiple table

I'm trying to create a calculated field, which returns the margin.
The part of the Select statement looks like this...
Sum(IIf    ([TOTAL_PRICE]=0,0,
IIf([TOTAL_PROFIT]=0,0,([TOTAL_PROFIT]/[TOTAL_PRICE])*100)     )) AS MARGIN

I have a two level security system to protect my data. The first uses the MS
Access security, the second is a simple login system wherby a user enters
their name and personal password to gain a customised view of the screen eg
if the user is me, I can see all tool bars, other ...

Who can help me ?
I 've a number ( sum of minutes )   and I want to show it like HH:MM .
exemple  1565   like 26:05
Thanks for your help

I have a small table that has been imported from an ExCel file containing
some instrument info. The fields are:
Denomination
Type

Hello, thx for reading.
shopping for groceries will be a perfect analogy for my needs.
What I want is to get the total bill (sum of all items) for shoppers in
any given day, but only for the people with ketchup or cereal on their

My query includes a date field (namely named 'Date') which, when exported,
includes the data, plus the addition of  a null time (0:00:00). My table
field is set as a Date/Time field, and is formatted for just the date
(YYYY-MM-DD). If I switch the table field to a text field, ...

How can I insert autonumber field in my query.
This is my 2 Table
Table1 has 4 field: A, B, C and D
Table2 has 3 field: B, M and N

I'm trying to write a simple pass through query to return a filtered
selection of transaction data from a SQL Server database. In one field
(works_order) I need to return a particular result if the transaction type is
"COMP" and a different result in all other cases. I have ...

I am a total newbie to Access...I have a simple database that I created for
my event's participants for last year's event. Now I would like to create a
database for this year's events.
Easily 50% of the participants will be repeats from last year...How do I add