Could one of you clever pros kindly try to point me in the right direction;
When creating a query, I get the error message "Invalid use of Null". I have
used the Nz function in all the calculations, to no avail. If I could know
why this error is generated, I might be able to find ...

I have the following query (this is a test of a larger one):
TEST: IIf([Next Gas Well Gas Sample Due]<Now(),"OVERDUE"," ")
Today's date is 3/21/2007  (which the NOW() function is displaying correctly)
Next Gas Well Gas Sample Due is a calculated field and is returning the

Hi, still new to all of this.  Simple question I'm sure.  I have an account
number that is approx. 9 digits long, however I want to write an expression
to show me only the last 4 digits of that 9 diget account #.
How do I do this...........

I have an interesting SQL to write and not sure how to go about it.
I need to sum the product of a two fields.
Table Pricing
Provider driver_id conversion accomp_id year_1_accom

I've four tables with the following fields:
Ta:
Agent_ID
Claim_Date

We have Access 2003.  Is there a way to automate the query?  This query will
output records to a file.  I need to run this query daily and don't like to
run it manually?  Thanks.

If you have one field with a running sum total of monthly expenses, that goes
from 0 to 10, the query would produce a list of each individual monthly
expense value. The first monthly expense would  "0",  the remaining 10
monthly expenses would be "1". Can I create a query which ...

This one is driving me nuts.
I am joining a table with a query on six fields to get to a unique row level
join.  The table is the complete record set and the query is a subset with
some additional calculations.  When I left join the six fields the resulting

Having Problems...I have to write some queries based on a starting
date. Normally I'll set up a text box in the form, have the user enter
the date in that text box and pull the date from there in my query as
such "like Forms.formName.textboxName". This has worked great except

I have one table that houses questions (Question1, Question2, etc) and each
one has a value associated with it (1,3,2...etc). I have another table "Score
Scale" that has those values 1,2,3,4,5 and each of those values has a
corresponding "Score" to it.  1=100, 2=90, etc etc.  

I have filter on a data/time field.

When I input this query it does produce the results between the specified
two dates.  I have checked the values in the VBA immediate window for the

I hope someone can help me.... I am trying to set criteria to a date field
that  exceeds 15 days consecutively based on criteria set from other fields
in the same table. I would like to see only those records exceeds 15 days
consecutively.

The query shown below returns no records.  The criteria entered direcly
without the iif performs as intended, e.g. '[forms].[fmChkList].[cbSeu] OR 1'
works if entered without the IIF expression, but as the value returned by the
iif finds no records.  Note:  The appostrophes in my ...

I am trying to make a query in access based on 2 different dates.
Date 1= In Patient Date  - member x admitted to the hospital on 2/3/2007
Date 2= PcP visit Date  PCP visits on  12/20/2006, 1/14/2007,1/31/2007 I
need to no how to get the 1/31/2007.

I have several tables with different numbers of fields.  An example of the
fields in one of the tables is below.
    EmployeeID
    Date