I have created thiis formula " =[PRICE1]+[PRICE2]+[PRICE3]+[PRICE4]+[PRICE5]
" to total the value of the five fields named above, I have to enter data in
all five fieldsfor it to work. How can I get it to total when i only have to
use a partial number of the fields?

According to this page:
http://support.microsoft.com/kb/295619/en-us
Microsoft says the IsNull(fax.value) will evaluate to False when fax.value =
Null. Well it's a good thing I didn't bother to read that article until afer

I have a form "frmRepairerTotals" - based on a query "qryRepairerTotals"
which has two fields :- Repairer1 (text) and RepTotal (GroupBy Sum). This
query is based on a union query "qryRepairAmounts" which has the following
SQL statement :-

Many tanks

Hi NG.
I  have a Table - Quiery an a Report.
The Reports contain fields:
First_Lastname

Am I crazy or could this be Done!!
My MS Access Database has a Form Called [frmCompanyInfo] their is say 4
fields That's have to have data
CompanyName

In an Access Report how do i round to the nearest multiple?
ex.   45263  Round to 45260
       45266 Round to 45270
Thanks,

 Is there a way to run update table to update a certain number of records
(determined by the user in an unbound txtbox on a form)?

I have been exporting data out of Access for the better part of two days.
What I am doing is highlighting the table, right-click, and then pick csv as
an export. One of the columns in my data should have 7 decimal places. When I
export it only has 2 decimal places. The column is ...

Hi, I have a table [Table1] with the fields laid out like this...
StationID
Date
Value

I have a database (FE + BE) in A2000 which has suffered some
corruption (I think). The problem is that the Break Point facility no
longer works. I can enter a break point (the line goes brown) but when
the code executes the break point is ignored. Other databases on the

I use a report to print out checklists that in the detail section have item
number to delineate each checklist item.  The item numbers as an example are
1-1, 1-2, 1-2a, 1-2b, or 2-1, 2-2, 2-3, 2-3a, 2-3b and so on.  The report is
grouped by checklist section and the grouping ...

I cannot get Access to display two hierarchically equal subdatasheets
together when the form is in datasheet view.  The both only are visible when
the form is in single form view.
tblCompanies

I have a spreadsheet with over 60K rows that I need to update with an
additional column of data.  Unfortunately it would be too much work to repull
the data and get it formatted appropriately.  I was planning to use vlookup
to complete the update but so far has been very time ...

Is there a way to join two queries together?
In query 1, i have Invoice ID, Description, and Total
In query 2, I have the same fields.  
I would like to see all the records from both queries.  Please advise.