Is there a way to determine what day a date is from a Date() so I can use it
in a formula?
Like 5/21/2005 is a Saturday and 5/22/2005 is a Sunday.  I noticed that the
Calendar in the form has a selection for what day to display first.  I would

Designing a form that will allow users to pull info on an individual customer
or all customers.  For example, query parameter [Customer ID] for an
individual customer, and  [some wild card character]  for all customers.
Sample form format:

I need to enter a date via a prompt that is then used by other field
criteria - is this possible?
I have a query that prompts for several dates, these prompts are set up in
field criteria e.g. field name PerEnd has its criteria set as [Enter Period

I need some advice on an update query please. I have a total of 7 tables, 6
of which need a field updated from the main table. The field in all 7 tables
is called the same: book_abbr. The main table is the table that holds the
updated abbreviation information, it is called  Books ...

HOW DO I CREATE A QUERY IN ACCESS 2003 THAT ONLY DISPLAYS CURRENT MONTH
TRANSACTIONS???

I have a query with 12 fields from 4 differant tables, I'm need to get the
user to search any of the fields, leaving some blank but still getting
results from the blank fields. I can't seem to get the quey to run without
asking for input from the fields that are blank. Any help ...

Project for school need to know how to create a crosstab query using
microsoft access.

I have a field in a query which returns the number of days since a
transaction i.e.
DaysOutstanding: (DateDiff("d",[TransactionDate],Date())
I'm trying to give the user the option to enter a range e.g. 0 to 60 days by

Is it possible to do this, or does it make better sense to format the fields
in a form based on the table?
The code I'm using is...
SELECT DISTINCT tblLinkedData.FSRef, tblLinkedData.Premises,

I am having problems getting my database to return all of the results I need.
I know it's a coding error, but I don't know how to fix it. I have a larg
table with multiple results [i.e. (BIO:104), (BIO:104, BIO:111), (BIO:111,
BIO:210), etc.]. How do I get the engine to return ...

I have a query that allows the user to select data by year Between
DateSerial([Enter Year:],1,1) And DateSerial([Enter Year:]+1,1,0) This works
great, however I would like them to be able to compare 2 years on a report so
I would like it to ask them [Enter Year1:] or [Enter Year2 ...

I have a table of bills. Each bill has a bill #. Each new bill is labeled
VER_NUM "001". When a bill is adjusted, the VER_NUM changes to "002". If the
same bill is adjusted a 2nd time, the VER_NUM changes to "003". I want to
create a query that will show only the last VER_NUM for ...

I have a quick question about SELECT queries....
say I have a simple Access database called tests containing the following
fields:
userid, test_date, test_type.

I have a date field in a 3rd party database where dates are stored as year,
month, day (i.e. May 6, 2005 is 20050506).
I have to enter the leading zero on single digit months or days to query (no
biggie) BUT ... I can filter from this date forward (>=[Starting Date]), but

I'm looking for a way to find all the records in a table which has equal
values in 3 specific fields.
Lets say I have a table named tblMyTable, which has 4 fields: Field1,
Field2, Field3, Field4.