Can I use a subquery to create a row of
data that can be used as data in an UPDATE.
I have a select something like...
SELECT (some expressione) AS Exp1

I have a Microsoft Access file with a lot of different fields, one being
date. How can I retreive information based on day of week? (i.e. all Mondays)

I have a table of employees and I need to pull the ones who have not taken
certain required training.    
thanks!!

I have a query pulling out birthdays from a staff database using part dates
in serial number form.  Currently the report is printing under each month (eg
'1', '2', '3') columns listing the date (eg 14(th), 23(rd), 25(th) etc), each
employees name and which office they are based ...

I am taking data from an Excel spreadsheet and moving it into Access.  The
Excel spreadsheet has several fields that don't match up with my Access
database.  In my Access database I have text field called Notes.  I would
like to take several fields in the spreadsheet and put them ...

hiya,
need some help, im trying to run a query whereby i need to search for "X" in
multiple fields, field A, field B, field C AND field D! if the query finds
"X" in atleast one field the query will display the entirity of the record!

I have a form with a sub-form inside it
Basically if a choose a location the sub-form expands to show whatever
items are in that location
It must be simple, but having looked at all the sites I know, I can

I have alot of ProdGroups so I would like to get the first unique part for
each prod group. Here's what current sample data shows:
PRODGROUP     PART#      VALID FROM        RATE
FX1                  ZZ12         05/05/2005        1.25

I must caculate the age monthly.
For example, A's birthday is 1980/01/01. On Feb, A is 25.18 years old;
                                                                 on  Mar, A
is 25.26 years old;

Hi,
I've got a table with few fields... I need to write query which shows me only
records that are not equal to one value. The field is text field. When I
write Not Like "*ZPSFN*" to that query, nothing is shown. There are about 20

Ok, I can set a number field to 0 with an update query, but how to you
completely clear a memo field back to blank?

I have this problem:
I have an Access database which looks like this:
<PRE>
Value 1 Value 2

I have 2 tables.  Job Info and RenoNew
Job Info includes:
Job #
Job Name

I'm trying to parse data in Access.  Taking a portion of a description field
and putting it into a new field.  I only want to grab the data up to the
first period (.) in the description field.  Is there a way to do this?

Hey Folks,
I have a gremlin which is really bloody frustrating. I have written a query
in my database (I am using Access 2000) that opens, but with no records, when
a user running Access 2002 opens it. It works fine for me??