I have a query that has a value of zero (by calculation) and when I run my
query I get the error: divison by zero.  I can't figure out how to set the
query to accept a NULL value.
Here is my formula:

I am using an Access database that contains the following fields:
ClientNumber, LastPaymentDate, LastPaymentAmount, 2ndLastPaymentDate,
2ndLastPaymentAmount
The database contains a history of the last 12 payment and amounts

This is what my sql for the query looks like.
SELECT tblPersonalInfo.MemberID, tblPersonalInfo.LastName,
tblPersonalInfo.FirstName, tblMemberAllergy.AllergyID,
tblMemberAllergy.Notes

I'm confused about the Is Null feature in queries.
I have a query that sums 25 values, val1, val2,val3.... From that i print
out a bar chart in a report that shows the magnitude of these values.  I
would like to ignore zero summed values so it fits nicer on the chart.  How

I am fairly new to Access. I need to query for special characters in fields
of a table. I have been successful in querrying for & ^ ( ) ones that HL7
will not take for interfacing. I am trying to query for a - but it will not
work. I type "-" just as I did the above. Is there ...

I have a date field set as text.  The filed needs to be text inorder for
other processes to work.  The data is entered in the format of  19750521,
this is equivilent to YYYYMMDD.  I am trying to write an anniversary query.  
In other words I need the query to pull the records ...

How can I find the most recent test date for each of a number of test results
for many people? Data is entered in this format: ID#, Date of test, score. A
person may have 1 or many dates of testing. I want to query for all ID#s with
the results for the most recent test date, even ...

Whenever I use the "Not Like" operator in a query Access changes it to "Not
ALike" which doesn't work! Does anyone know how to stop it from doing this or
what the cause of it is?

I have some fields in a table which store calculation results. I use update
query to update the fields. The calculation formula likes this: A*B/C. The
problem is if the feilds type in the table is Number, format is fixed and
Decimal places is  in 2, after update, the data like ...

a library with nearly 10000 books (or series) in 80 Book cases
each book has a uniqe id number
i have a library index table with 3 columns
From Serias    To Serias    BookCase#

I have two dates with respective times. The first date being [Onset date of
ischemic symptoms] with a time field of [Onset time of ischemic symptoms]. I
then have another date called [Arrival at participating Hospital date] with a
time field of [Arrival at participating Hospital ...

I am still quite new at Access so if there is a solution that does not
require intense coding in VB i'd prefer that soln, unless VB is
absolutely necessary.
Description:

I have a select query that returns a number of fields and I would like there
to be a column that will number each record in the results sequentially from
number one. I am not too good with SQL so will need the instructions using
the design grid.

I'm trying to run a query that shows specific store numbers. Each property
has multiple stores and I'm creating a range filter for each property, but I
have one property that has a range from 102-154 and I want to exclude stores
122-123. Here's my sql:

Is it possible to union join 2 cross tab query's?
I can get the 2 query's to union when they are not cross tabbed.  however
when I use the cross tabbed query's I get the error message;
'Characters found at the end of SQL Statement' - the characters are the word