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!

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

DSUM

Status
Not open for further replies.
bxgirl

bxgirl

Programmer
Joined
Nov 21, 2005
Messages
75
Location
US
I have a report based on a query with a text field whose control source property looks like the following:

=DSum("[Weekly Hours]","[PCW_BRONX]"," [Program] = 'SD'")

How can I have this print 0 if there is no data to calculate.
 
Sort by date Sort by votes
=NZ(DSum("[Weekly Hours]","[PCW_BRONX]"," [Program] = 'SD'"),0)
 
Upvote 0 Downvote
How are ya bxgirl . . .
Code: 
[blue]   =NZ(DSum("[Weekly Hours]","[PCW_BRONX]"," [Program] = 'SD'"))[/blue]

Calvin.gif
See Ya! . . . . . .
 
Upvote 0 Downvote
Thank you so much. That worked.



 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

rccline
  • Locked
  • Question Question
How to write the Dsum "WhereCondition" on Subform
Replies
2
Views
340
rccline
rccline
Jessica22
  • Locked
  • Question Question
dSumRecordset won't trigger and returning #Name? error
Replies
6
Views
443
Jessica22
Jessica22
murphy123
  • Locked
  • Question Question
DSum expression help
Replies
2
Views
106
TheAceMan1
TheAceMan1
gepol
  • Locked
  • Question Question
DSum Function Question
Replies
9
Views
313
gepol
gepol
44nato44
  • Locked
  • Question Question
MSAccess2000 - Dsum null value
Replies
4
Views
141
PWise
PWise

Part and Inventory Search

Sponsor

Back
Top