I need to create a new AutoNumber/Primary Key field in a make table query

I have a column that has department names in it. Some of the departments have
an apostrophe in the name. Some of the departments have a dash in them. When
I try to write a parameter query and type in the department with an
apostrophe or dash the query does not find a match. I ...

I have some data that has been imported into an access database from an
Excel spreadsheet.  One of the fields in the table (created from an Excel
file) is an address field in the following format:  Add1, Add2, Add3.
What I would like to do is append the data from the new table ...

I am querying a Invoice and Invoice Detail linked table by requesting the
YEAR value extracted from the date field in the invoice table and variety
value from the invoice detail table. Both tables contain values from several
years back.

[Posting on behalf of the customer as shes not able to access this site.]
What's wrong with my statement?  
ACCESS doesn't like the brackets - even when I remove the brackets before
and after the "!" ? Please help..

I have a query with several fields and want to use 3 or more criteria to make
it easier for the customer to find something. The fields I want to use
criteria are: Customer, Invoice No. and Invoice Date, but I want the customer
to write into 1, 2 or the 3 criteria and also look ...

I have a set of data which shows the answers to questions asked for a
particular month and year.  I have a query which will pull results for a
chosen month and year, which is entered through a form.  The fields that I
have in the query are "Question", "Month", "Year", "Date ...

I have two tables and I need to bring the matching Serial IDs from both
tables to produce the related fields i.e. Table one Serial ID matched with
Table two Serial ID which then produces the related records based on the one
Serial ID

I am trying to do a QBF and am having a problem when I try to use the
BETWEEN operator.
I have 2 text boxes on my form TxtFrom and TxtTo. The user might enter
values into both boxes or leave one of the 2 blank. Is still however

I have a query that has 4 fields - Officer; Team; Finalcost; Date
completed (charged).
Officer is set to Group By
Team - criteria reads <> "DI"

I have two tables. One contains imported data with a unique reference number
as the primary key the other table is supplementary and has no data in it and
I have a query that returns all the fields from this table and shows blank
fields from the supplementary table. The reference ...

I have the query below that I used an IIF statement to classified the
different band..
Is that possible to show me in only one column the different
classification? Because now it shows in 5 different column..

I am running an update query which updates a number of fields and would like
to re-use this frequently as I get new data in that needs to be processed.  I
assumed that by moving the new data into the table referenced in the query
(and moving the previously processed data out) I ...

I am trying to create a query with two diferent tabes.  I have linked the
tables  when I use the query wizard I get an subscipt out of range.  Can
someone please explain why I might be geting this message.

I'm trying to setup a query that will return all data that has been created 1
hour ago.
In the data input form there is a filed that ask for todays date, when i run
the query i want to find all dates that were entered into this field 1 hour