if someone could help me write this query I'd really appreciate it.
I want it to return the lessor of the two dates:
so it would be in english is account open date is less then the referral date
then account open date else referral date.

I have created a query in Access 2002 using fields from two tables. The query
is duplicating data so that each line item is listed multiple times. I can
specify with more details if someone thinks they can help. Can you?

Could someone assist with the following query?
In short, I want to see the count of updates per day, and a total,
from 3 different tables. The query runs OK, however the information is
incorrect as the totals decrease on a daily basis (as time goes on)

I have a query (see SQL below) that connects 2 tables: Contacts and Orgs.
Each table has the field Organization in it. That field is the linking field
between the two, and it is the primary key of the Orgs table. All tables
have referential integrity.

I have the following expression in my query:
Expr2: IIf([SCHW ADV NETWORK - New]="Yes",[TOTAL FEE]-0)
The choice is now not only "Yes" but "Yes - New" and I want the same thing
to happen for either choice    TOTAL FEE - 0.  How do I add this to the

Imported data from Works database, dates are in format dd.mm.yyyy.  Several
dates in same record of field.  I want user to be able to enter parameter of
the year only when running a query.  What criteria should I use, and what
should the input be from the user?

Wonder if someone maybe able to help me please.
I have a database at work that contains details of test files. One of the
fields for each test shows that actual error that caused the file to fail.
The problem is, is that there is an awful lot of text from this field that I

I have a query with a date/time field.  I'd like to write a criteria to only
show records => 5:30pm for all dates in the dataset.  I know this should be
easy, but I'm stumped.

I need help!
I am trying to copy a long list of queries from one access database to
another.
I tried "get external data", but it brought the actual data from the old

I am trying to add the freight from a purchase along with the unit price and
sales tax using Sum. When I add my freight amount, it multiplies the total
freight amount by the number of items in the purchase. Below is the
expression I am using in my query...can anyone please help.. ...

I have the following query:
SELECT    *  
FROM          { oj { oj [ACCT MGR QTR GOALS] LEFT OUTER JOIN
                     [ACCOUNT MANAGER] ON [ACCT MGR QTR GOALS].

i would like to use a wildcard search in a prompt window for a query

Hello, i like to add more fields as a criteria to the strWhere...........i
like to [RequiredDate], [ID], and other fields...can anyone help with this. i
am stuck with this. thanks.....
   lngLen = Len(strWhere) - 1

I am new with access 2003.  I set up date format in table.  When I query a
date range criteria between "4/15/2007" and "4/20/2007", why "4/2/2007" show
up?  How can I fix this problem?
Thanks,

Please can anyone help me with the following query:-
I am trying to create an inventory application in Access 2007.
I have created a Stock table (info stored on each shoe), a Warehouse table
(where stock is kept). A Transactions table (info stored on each transaction).