| View previous topic :: View next topic |
| Author |
Message |
franke
Master Poster
Joined: 26 Jun 2004
Posts: 161
Location: Indiana, USA
|
 Posted: Fri Dec 28, 2007 1:56 pm Post subject: Return 0 for a field in a report |
 |
|
How can I display or return 0 for a field in a report if the query returns a null for the value?
Instead of having blanks on the report I want to show "0.00"
Thanks.
_________________
--------------------------
Thanks for everything. |
|
| Back to top |
|
 |
BillyB
Frequent Poster
Joined: 27 Jul 2005
Posts: 60
Location: Lexington, KY, USA
|
| Posted: Fri Dec 28, 2007 2:00 pm Post subject: |
|
|
You can use the Nz function.
Selct the field you want on the report, go to Control Source and do this:
Where "Sep" is your field.
Be carfull that the Name of the control is not the same thing, if it is change the Name to something like "tbxSep"
That should do it. 
_________________
I'd rather be making chairs. |
|
| Back to top |
|
|
franke
Master Poster
Joined: 26 Jun 2004
Posts: 161
Location: Indiana, USA
|
| Posted: Fri Dec 28, 2007 2:54 pm Post subject: |
|
|
Hey, that did it 
Thanks a bunch |
|
| Back to top |
|
|
|
FAQ
Search
Memberlist
Usergroups
Register
Profile
Log in to check your private messages
Log in
