Dsum but £0.00 if null

  • Thread starter Thread starter Simon
  • Start date Start date
S

Simon

I have the following code that runs on a press on a button and puts a
currently number in, however if the calcualtion is null how do i get
it to put a £0.00 in the field and not leave it blank

MonthHireTurnover = DSum("[SumOfSubTotal]", "Query8", "[SaleYear]=" &
NowYear & " And [SaleMonth]=" & NowMonth & " And [OrderType]= 3"



Thanks
 
Try putting the Nz() function around your DSum so you can specify to
make it zero when null.

Nz(DSum(...........), 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

DSum Countrol Source Help 5
Dsum-in subform_footer (passing value back into subform 6
running totals 5
DSum Acting Weird 2
DSum Executing Too Late 5
WHAT IS WRONG WITH THIS CODE? 9
Changing existing code to add "IF Statement" 7
DSum Code 9

Back
Top