I have an urgent need for a report and I cannot figure out the SQL to
give me what I want here.
I have a table called Records_T which has the following definition:
ID - Autogenerated number

I am trying to update data,
I have tile numbers, but would like to select many tiles at a time.
eg. tile:72e01a01
when i use wildcards to select more than one tile and run the query it

I have a form that is populated with a query.  When I have a list box on the
form to identify the record to populate the form, I can easily trap the
event.  I basically want to make some controls visible or not.  When I open
the form and use my mouse wheel to run down through the ...

One of you MVP guys helped me out with the SQL code to update one table using
another table (thx for that). Now, I want to add code to append any records
found in the update table that do not exist in the main table. Hopefully it's
possible to combine them and only have to run ...

I am trying to select multiple Yes/No fields with each filter interdependent
of one another. What is happening is once it filters the first yes/no column,
the remainder base it upon the results.
Can anyone provide assistance?

Help! I'm hitting a brick wall. I need to create a full outer join from 2
tables called inventory and aw pc assets but cannot get my syntax to work.
Here's what I have. Can someone please assist?
SELECT Inventory.*,Aw pc assets.*

Guys & Gals
Apparently my previous message is either being ignore or not being
considered worthy of anyone challenge in this forum:
Below is the data in the field CHRDES

Excel 2000
I've got a column of data.
I want the average of that data from the first line through any given line.  
I'll give an example below.

If I have a table with columns:  Assignment - User names -  then 65 different
security columns.  The Assignment could be Booking then a user name  then a Y
or N in the 65 security columns.  
 I want to Group the Assignment, then pull out all the users that have Y's

I am trying to use a field from the current record in a table as a where
clause parameter in a Lookup query. I don't know how to reference the current
record in a table from this lookup query... Any ideas?

i have a field in a query consisting of both text and numbers.
sample field data :  "ps-re 38107" "ps-bmw  39155" "ar- 46505888"
i want to manipulate the data (create field  expression) in order to have
only the number contained in  each field (i.e. without text and spaces)

friends,
Q.1: I have table "HMADetail" That has fields as
Date  Lot#  SubLot#  HMAPlacedToDay   HMAPlacedToDate  .......
(1)      (2)     (3)                (4)                         (5)

I can't figure out how to do this.
I have an Access Database 03' that manages our Service Calls. I have over 5K
customers in the database that were exported from our main company database
(txt converted to excel). Every few day's or so, I want to export the

I cant get this to work.
So I think I need some professional help here.   :)
SELECT [3ExpPL].PL, [3ExpPL].Article, [3ExpPL].Size,
DLookUp("[4EAN]","[4EAN]","[ArticleNumber] = [Article]" And "[Size] =

Hello I am a newbie in Access 97.
When I run the query :
SELECT DISTINCTROW MAX (TbTrans1.Date)
FROM TbTrans1