Add on to formula

M

Michelle

Is it possible to add on to this formula to state that if no value to enter 0?
=DSum("[CrGiBgChecked]","[1 deskiewicz]")
 
M

Marshall Barton

Michelle said:
Is it possible to add on to this formula to state that if no value to enter 0?
=DSum("[CrGiBgChecked]","[1 deskiewicz]")
Click to expand...


=Nz(DSum("[CrGiBgChecked]","[1 deskiewicz]"), 0)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calculating on one query several different items 0
Newbie Help - IF Yes No Function 0
Autonumber field in Excel that behaves the same as Access 0
DESPERATE NEED HELP ASAP Totaling seperate fields in one query 2
Use TODAY() function as the criteria in a SUMIF formula 1
Add-Ins for Outlook (Mac) ? 0
Student & Home? 1
Dsum and Dmax with structured references 1

Top