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 IamaSherpa 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
Nov 21, 2005
75
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
Status
Not open for further replies.

Similar threads

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

Part and Inventory Search

Sponsor

Back
Top