Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

performing calculation text box controls

Status
Not open for further replies.

sabascal

IS-IT--Management
Aug 20, 2002
85
GB
Background
- I am working on a report containing multiple text box controls.
- Given a record of my source Table, those controls have for data source different columns of my table.
- The data retrieved should be numbers, but for some reason, my table sometimes contains empty/null values instead of having a zero.(this is a cross tab...)

My problem:
- If I try to make a sum of a set of controls that contains a null/empty value it returns null/empty

Question:
What is the trick to handle this without modifying the table (cross tab... not easy to modify).
I tried something like:

Switch(["Name of Control"]="",0)

but does not work.

Could somebody help on this?

Cheers,
Seb
 
Hi

Try =Nz([Controlname],0)

Hope this helps Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
UK
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top