I am doing some calculations in a field that have some zeros and I get
#error since I can not divide by zero (I know this too). Is there a way that
I can convert #Error to a zero?
Eric

I know how to use the DateAdd command on adding months.
DateAdd("m", 45, ThisDate)  However I need to insert the last day of the
month.
6/2/05 + 45 = 3/3/09  I need the answer to be 3/31/09.

I have a query that filters data based on a field Status.  I want to return
all but two items; "Completed" and "Archived".  I know this should be simple
but I can't get them to work togeather.  Please help

I am currently using the following query to determine which invoices remain
unpaid since the first of the year in our invoice processing database.
Currently the query is based on the following and you must re-enter each
month separately. As an example, if I wanted to know which ...

A quick question (I hope).
I've got a field which have numbers in them which I need to pack to
four-digits with preceding zeros.  To enable this I've changed the data type
to text but I can't think how to achieve it.

I have this code and I need to convert this to a query.  The reason it is a
new field and the current records being entered will do this but I also need
to update the old records also.  So can anyone help guide me in making a
Update query for this code?

Can someone tell me how to se the level of precision when defining criteria
for a field.  For example:  I am trying to limit my result set to anything >
0 but I have noticed that when I use only >0 it will some times drop off
smaller numbers like .02.  Any help would be ...

I am in a bit of a confused mode at the moment.
I am building a new query to get data that is linked between an access 97
front end database and a sql server 7 backend.  The situation is as follows:
I have multiple tables that contain seismic data.  From this collection of

Running A2k
I have to export data from Access to QuickBooks.  Part of that is the
addresses for customers.  The problem is, QuickBooks views the address field
as one piece of data, like a mailing label.

I need help with an iif statement in a query.  Basically I have a form that
the person uses to either choose a month or choose all months using option
buttons.  The statement reads -- IIf([Forms]![Invtrany
info]![Month]=99,Between 1 And 12,[Forms]![Invtrany info]![Month]).  It ...

Is it possible to enter a range in the criteria box?  For example WE 051405 -
WE 052105.  What I would like to do is enter a criteria of [enter desired
periods] then when prompted the users types WE 051405 - WE 052105.
Thanks,

I want to count the number of groups returned by a query. Conversely can some
one help me in creating a query which will take a number like 3 or 4 or 5 as
input and return those many groups of record.

I have a database that records several times.  I need to report on time
intervals for several points.  I am using a select query to gather the data.  
Several of the time intervals are variable.  Example
Interval 1

The SQL view of my query is as follows:
SELECT IIf([Order]>819000000,"PP02","PP01") AS Type, Sum([tblWIP].[Amount])
AS Amt
FROM tblWIP

I have linked two table from excel database. What i want is the data from
both table in one table but i am not getting data i want. Once i run the
query it gives me to many data which duplicate (there are 2 data in both
table so new table should reflect the only 8 data but it is ...