I am implementing an access database and need an autonumber field to
automatically fill in when a new record is created. I need the field to be in
the following format...
QN then 5 digit number starting from 06700 or around there then the last two

I have a simple Update statement,
Update [To Append] INNER JOIN [MAPPINGS_DISTINCT] ON [To Append].Make =
[MAPPINGS_DISTINCT].Make SET [To Append].Make =
[MAPPINGS_DISTINCT].MappMake

This seems like such a simple thing to do but I just can't seem to get
started. I want to create a query that allows me to enter the Name and
despription in one table by typing it by hand when asked to.
It should add the counter automatically and then it should create

I don't even know if I'm in the right place to ask the question. Please help
if you can.
Everyday, I open an Access database that reads from some other bigger
database via ODBC. I have a query that pulls a few columns of data into

I keep getting error when trying to add a new autonumbered field to files
with >50,000 records. Error messages suggests changing the  MAXLOCKSPERFILE
setting in registry. How much more than its default 9500 can I go? Is it
affected by RAM?

I am using an Access query with fields in a specific order to create an
Excal file which will later be used as data to import elsewhere.
I am finding that the the output dynaset of the query does not have the
same order of the columns as the query by example grid.

I'm writing a query and I'm getting a syntax error but I'm not seeing it
when I look at it and the error message isn't telling me where it is at.  For
starters, does anyone see my mistake, and better yet does anyone know of a
bug hunting software that will give better details as ...

I have a global var "G_NAME"
I would like to use it in a query.
Is it posible?????????????????
Scott Burke

I have a query that pulls project numbers, task numbers, and cost types. I
want the parameters to ask for two project numbers, and task number and a
cost type but I want the fields to be optional. I know this should be simple
but for some reason I can't get it to work.

I have a table arranged thusly
Reason      Status     Est Comp Date   PMDate     Tool#
                                                       7/14/06
WFT083

I have two tables with a one to many relationship, well call them A and B.
I have a continuous recordset form based upon this relationship.
The issue I'm having is I only want the Last value of B to show up - meaning
I do not wan't multiple lines from A for each B, just one.

I am having a problem with an update query for an inventory control form.
There are several bin locations with a numeric field for how many there are
in each bin.  Then there is another field for each bin for when they do a
physical count.

I'm running a query that requires that I convert a YYYYMMDD text
formated field to a valid date, then use the converted date to
determine the person's current age.  I'm creating a new field with this
expression:

Hi! I hope I have this in the right discussion group. Here is my problem:  I
have a form which is to be used to enter query criteria for up to 14 fields.
I can get it to work, for the most part, by putting  
[Forms]![FormName]![TextBoxName]

I have a simple dilemma that I just can't seem to solve. I have two
tables: tblfromXLS and tblwebmaster. I need to use an SQL statement
that will check the variable SSN (used in both tables) in tblfromXLS
against the variable SSN in tblwebmaster.  Basically, I need to