Hello. I have been trying to update a field using the value of the
same field in a different row. I have an policy table that has a
postal code field. There are several records per policy but not all
have the postal code filled in (the field was just recently added to

I have a stock table which has serial numbers for each item.  I want a query
which groups the item types and shows the first and last serial numbers for
that item type along with how many.  Eg. 10 x mobile phones first serial
number = xxx1, last serial number = xx10.

From vb.net I create a table with columns  with this SQL:
strSQL = "Create Table tmpItems ([id] Counter,[ProgTexst] text(150)
Null,[PosNo] int Null,[PlcGroup] int Null,[LimitNo] int,[Machine]
YesNo,PRIMARY KEY(id)) "

I am trying to query 5 .mdb files which have their own tables, queries,
reports.  Each DB table covers a product such as snack food, soda, water,
milk, ice cream based on customer purchases.  There are obviously duplicate
customers in each table.  All customers have a unique ID ...

I am trying to create an IIF statement where if Plan="den1" then look to see
if plan="med1" return "medical" if not return Plan. What I am trying to do
is if a person has DEN1 then look to see if they have MED1 and if they do
return MEDICAL if not return whatever the Plan is ...

I have a field in a query named Field1 (e.g.). Can I use code to set the
source for the field?
e.g. The following works in the query grid, but I would like to create a
function to do the same.

Some time ago I asked this question and was told it couldn't be done.
Well, I'm asking it again. I know there is no existing MS Access function to
do this (using access 2003).
Is it possible to create a function to do it?

I posted this in the general questions and was referred to queries:

I have a database I import from Outlook, and am keeping a list of all active
recruits.  Each week, I need to update 10 logical fields to see how many more
entries were made to each logical question.  What is the best way to get my
results.  I created a query with these fields ...

Without having to export my data out of Access and do a find/replace in Excel
then re-insert back into Access...  How can I query "Column1", which has data
exactly like "C1234567", remove the letter in front of the 7 numbers, and
keep the 7 numbers?

I have a query which compares the current record's create time with the
previous record's create time, which gives me the number of seconds elapsed
between button presses. All works fine, except the first record is blank. I
want it to say either zero or 1 second, regardless of ...

I think this is a bug. I remember in my old Access V1 book (yes I read it)
that the author continually stressed that data in tables is unordered. I also
believe this query worked up through Access 95 and stopped working in Access
2000. Here is the setup:

I am creating a parameter query where I want to pull data between 2 dates.  
In the date criteria of my query, if I write between #01/01/2008# and
#01/31/2008# +1, I will get all data for January.  If I use a form to enter
the dates and have  Between [Forms]![autoexec]![start] And ...

I am trying to update a columns with a column from a subquery and I receive
"an operation must use updateable query"
UPDATE MyTable SET MyField = (Select TheField from TheTable where TheField >1)
How should I do this?

The following SQL Statement will only show 3 items no matter how many  items
meet the criteria and I cannot understand why:
SELECT [Meals Defined].MealDate, [Meals Defined].Meal, [Meals
Defined].Quantity, FoodItems.ServSize, FoodItems.ServUnits,