I have an Access table built with some relationships.  It has an autonumber
as Primary Key.  I have an Excel file with all (except Primary Key) fields
the same.
I want to update the records from the linked Excel file.  I'll never know

Is it possible to somehow set the input to select top to a variable or at
least use some other method to get the same effect. If I could just use
something like select top (query.variable) etc etc that would be great but
it obviously doesn't work. I want to be able to use other ...

Since Access XP wont work with templates from 2000, where do I get templates
for my version of Access?  Microsoft jumps from 2000 to 2003 with absolutely
NOTHING for my version.  Why do I feel "Black-Listed"?

Is It Possible To Generate An Auto-Incrementing Field?
You know a field which just counts to the last record.
Field Name
1

I am trying to setup a query or queries to pull data from a drop down list.
Here is the problem: I have 2 tables that store the data. One table contains
budget data and the other actual data. Both tables have 5 different cost
areas (US, Canada, Asia, Japan, Mexico). The common ...

I have two tables. The first is a masterlist of 25,000 city street names,
with correct postcodes. The second table has 1,340 streetnames, but no
postcodes. I want to be able to ‘transfer’ the postcodes from the masterlist
to the ‘live’ list table with the minimum of hassle.

THIS IS THE SAMPLE DATE
I want to see supplierID, sum of amount shipped and sum of amount not
shipped, and group them by suppier, total no of orders accpted by
supplier,

I have a table with fields artefact (text), not_damage (text)
but i need to write a query so it can shows me which artefact and also
count the number of artefact that is damage and not damage... how can I
do that?

I have a table that I've imported to Access 2002 SP3 from SQL Server 2000,
and I cannot get two of the columns to display.  I've looked in the design
window and at properties, but I see no reason why these two columns shouldn't
display.  In a query, I can assign criteria to ...

I have set up an mdb for a user - when he uses a single-table query to locate
and edit column values in a record, the edits appear to be saved, but, if he
looks at the table itself, the changes are not saved.  I can edit and save in
queries in other databases, but I'm not sure ...

I'm running an UPDATE query, however, when the filed name has a space in
front of a bracket, access deletes the space when the query is saved.
For example, when I have:
SET [Palletizing (Robots)] = Nz([Palletizing (Robots)],0),

Is there a way to use a combo box or some sort of coding to select specific
fields from a query?
I have a query that combines data from 2 tables. Each field represents
actual or budget data for several different cost centers. The query gives me

I am querying 2 tables from different sources and the link is customer
account number
I want to know how to query what account numbers are missing from one of the
tables

I have 2 tables, "monitor_configurations" & "Sensors"
Monitor_configurations has fields :VelocityA, VelocityB, VelocityC all text
type storing the serial of the sensor that is plugged into the monitor at
that port.  

I created a select query to get different fields from different tables.  Two
of the fields are Memo fields.  Both of the fields are truncated at 255
characters.  I created an Update query to see if it would handle the Memo
fields correctly and it performed as it should.  Is there ...