I have a table that I want to INSERT the entries into another table, easy
enough with an Append Query, but if the insert fails, due to duplicate keys,
I just want to update a few fields.
Any ideas?

First Off - I'm not very advanced when it comes to access.  But I have two
tables:  tbl_employees & tbl_violations.  I want to find out how many times
an employee has a violation so I created this query using the group by (their
name) and count function (violation).  It works ...

I have a form with a lookup box. The user types in the part number they want
to find. If they type in the wrong part number I want to be able to find the
next closest item. How would I do this?
This is the current code:

I have a SQL query I want to write to pull data to add weely node utilization
percentages.
The db is
area--->headend--->router--->routerports--->transmitter--->nodes--->nodeNames

Is there a way to invoke an MS-Access query via ODBC?
Sorry if this is in the wrong thread.....
Kind Regards,
Pat.

I'm trying to write a query that selects records based on a date range
and
Uses the Date of Birth if the Date entered is blank (null) or uses the
date entered if that date is filled in.

This is an example of what I need to do. (The data is from an outside source
so I am stuck with format)
lookup
id  | value

I am using an Access database to store biographical info on members of our
schools foundation board.  From this database, I will also print out
directories, mailings, etc. etc.  One of the publications we print is a
profile directory which contains a picture of the member.

Hi, I have a table that lists authors by 2 fieds (last name and first name)
among other information, like journal title, etc.  What I need to do is
assign a unique identifier to each unique author.  There are many duplicate
author names because they have authored more than one ...

Reading many helpful responses on this site, but unfortunately none of them
seem to remedy my current issue.
Just learning Access, took a quick college prep course, got the basics.  Now
I am expanding freelance.  SO the scenarios is my test idea that I have

I have a table set up with Date, Vehicle Number, Start Mileage and End
Mileage.
I want to be able to pull up the start mileage on the 1st of the month and
the end mileage on the last day of the month.

I have a query that is join to tables on date fields in the diferrent
tables. If I click to run the query it runs just fine and produces
data correctly. However, if I try to go into design view it says
"Microsoft Office Access can't represent the join expression

Hello,
I have a query for some vegetation sampling data.
The 4 tables are set up like this arrows indicated linked fields (note: I
didn't design the database)

Estou neste momento a lidar com worksheets de tamanho muito elevado, mesmo
retirando as fórmulas para os tornar menos "pesados" eles continuam
extremamente díficeis de trabalhar, um amigo sugeriu que eu usa-se o
Microsoft Acess, o que realmente é conveniente para este tipo de ...

This seems simple enough but I just can't figure it out.
I have three tables, Repairs, Parts, and Items.  The Repairs table contains
a Repair ID (PK) for each repair and an Equipment ID (FK), and Date of
repair.  Many repairs can be done to the same piece of equipment.  The Parts