I have a problem with autonumber field in my project: when I deleted some
last records, it seems MS Access saved the last number of the autonumber. So
when I added a new record, the number would be skipped from the previous
record.

Hello...I have been following some of the other questions that deal with this
problem...error 3086 "Could not delete from specified tables"...but I have
not been able to resolve my problem. I have other tables where I use a delete
query and they continue to work fine...just think ...

I'm sure I'm missing something super easy.  How does one calculate the
number of minutes between a field in a Query "ActualDateTime", and a
semi-constant, like Date()+1 8:30:00 AM?
TIA,

Okay I'm trying to get a table to load into another one through a
series of queries.  I'm am using SQL statements to do this.  The name
of the table that I'm trying to get information into is called
Detailed_Forecast.  The name of the queries that I wrote are

I need a query that will take the input min and max and find the records
inbetween, but also if no min valued entered then all results bellow max and
if no max value all above the min.

I have written a query that delivers me a one cell response
Field [File Reference]
Table [Name]
Total: Count

I have created a form where the SVP field is a record selector and the
other fields are just used to change the parameters of the query. They
dont seem to work however. Here is my SQL:
SELECT [Master Sales Forecast].Account, [Master Sales

I have three linked tables
Documents: containing a primary key (DocID) and two text fields (DocNum and
DocName)
Revisions: containing a primary key (RevID), a link to the document table

I've a table with a field storing Fullname and tries to split that field
into FirstName and LastName.
To pick out Firstname goes well with this:
Left(Fullname,InStr(FullName," ")-1) AS FirstName¨

I am new to Access and am working with a preexisting database that I did not
create, so please bear wiith me.  I trying to create a query that combines
individual fields to create a mailing list where the names of married couples
appears as Mr. & Mrs. Joe Smith.  I'm using the ...

I'm stumped  
I made a select query which selects records from  table A that have a
matching value in another table B (using one field in each table).  300
records are returnd.  If I change it to an update query, only 250 records in

I am trying to search mulltiple fields for the same but multiple data.
each record contains 10product feilds i need to search all for a product, to
be input by the user,the products do not always occur in the same field i can
do this for one product. I need to do it for upto ...

I have table with two fields. One field is number and other one refrence codes.
Number of rows for a given number varies. I want to convert table to a query
with one row per number and all refernce code info into multiple columns.
E.g  Input Data (Number of occurences of "1" can ...

I am having a problem constructing the proper clause for querying my
database. I have multiple values used in computing daily averages of
constituent data for measurements. An example of my table for my table
[tbl_data] is shown below;

I am relatively new to dcounts.  I have a table with one field containing
values a,b,c,d,e,f.  In the query I have 3 calculated fields
(Staging,Success,Variance) which is a combination of record counts (i.e. a+c,
a-d-e-c+b,etc).