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 gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

#error DSum 1

Status
Not open for further replies.
vttech

vttech

Technical User
Jan 28, 2006
297
US
The Following statement below that I place in a text box control source works if their are values that meet the criteria.
But if no criteria are found I get an #error statement instead of 0. How can I resolve this issue??

Code: 
=Format(DSum("(([logout]-[login])*24)","tblLogInOut","[activity]='work' and [employeeID]=reports!rptBiWeekly!txtEmployeeID "),"#.00")


Newbie in search of knowledge
 
Sort by date Sort by votes
Wrap the NZ function around your expression...

Code: 
= Nz(Format(DSum("(([logout]-[login])*24)","tblLogInOut","[activity]='work' and [employeeID]=reports!rptBiWeekly!txtEmployeeID "),"#.00"), 0)
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

soloracer
  • Locked
  • Question
Problem using report recordsource values within report events. Error 2427 1
Replies
17
Views
383
soloracer
soloracer
JoPaBC
  • Locked
  • Question
Rounding error
Replies
4
Views
157
JoPaBC
JoPaBC
Triacona
  • Locked
  • Question
run-time error 2585 - action can't be carried out - while using DoCmd.SendObject acSendReport 1
Replies
17
Views
407
Triacona
Triacona
monkeysee
  • Locked
  • Question
Syntex Error (missing operator) in query expression
Replies
5
Views
160
dhookom
dhookom
JimStrand
  • Locked
  • Question
DoCmd.SendObject Compile Error - Sub Or function Not Defined 1
Replies
5
Views
197
JimStrand
JimStrand

Part and Inventory Search

Sponsor

Back
Top