Is it possible with a date/time field in the General Date format (mm/dd/yyyy
hh:mm:ss) to query based on the Day of the week??
Trying to isolate entries from between Monday - Friday with the General Date
format.

I have two tables for managing our sales orders.  One has the order header
info such as customer name, account number, etc and the other stores the
order line info such as productID, unit price, qnty, etc.  The tables have a
one to many relationship and are joined using the ...

I am trying to make a database and one field is a list of supervisors, I
would like the list of employees that report to that supervisor to show up.  
I have two tables.
table 1

I want to use Access  2003 as front end and SQL server as back end. I have
linked tables to SQL but I can`t modify the tables.

I have table access database 2003 with one column have data in this format:
yyyymmdd eg 20071022 ( mean 22 Oct 2007), 20070914 (mean 14 Sept 2007)
My question is: Is there anyway that I can convert  that format yyyymmdd (eg
20071022) into dd-mm-yyyy (22-10-2007) by creating query?

I have a table with the following values:
Date          StaffName ExpenseType    Amount    Details
10/10/2007 Staff1       Medical            $50.00     Attached medical
cretificate

have a quandry....am looking thru Text Functions but not coming up with a
solution.
In a text string (part number codes) I need to be able to identify those
with 3 digits to the left of a decimal point .  .

I have a simple one to many select query: Customers > Invoices
This query has worked properly for several years. All of a sudden I can't
update information on the Invoices side of the query and get a "this
recordset is not updateable" error. It's got to be a data thing because the

Can I set a verbal in VBA code that a query can the use as part of the
criteria for the query.
I am doing an update query on a set of data it runs find by its self. but
when a run it from code it can not read the combo box I have with the current

Greetings... relative Newbie here.
Working with a database getting external data which has the date & time in
the same field (i.e. 9/20/2007 2:56:00 PM).  I am wanting to create a query
to isolate any records between 6:00am and 9:00pm but on any date.  Pls Help!!

Let me try again:
TIA very much:
Is it possible to change and existing Query Object's criteria via VB code??
If so how might it be done?

I have a query that I want to use on another table that has identical fields.
How can I change the underlying table and save as....

Trying to update a Notes Filed with a combination of several other fields,
some of which are blank. The query only seems to work for records that have
all fields populated. An example of the desired output whould be...
F1  F2  F3  F4  NOTES

A simple aggregate Query is Grouping on 4 Fields (one Field uses a
Lookup..but I see NO "duplicates" in that).
Then I run "sum"s on several Long Integer Fields.
Result = a few (4) "duplicate aggregate values".

I'm trying to write a query that will return a median for various
values taken from a previous query.  I've seen some suggestions in my
searching, but I haven't been able to get them working.  They are also
all from before 2003 and refer to Access 97 and 2000.