DSum

  • Thread starter Thread starter Tray
  • Start date Start date
T

Tray

Im using a DSum function on my form to total a column in a query. However,
when there are no records that meet the criteria, the DSum field is blank.
How can I make it show a 0 instead of just an empty textbox??
 
You can probably wrap the whole expression in the Nz function:
Nz(DSum("SomeField","SomeTable"),0)
It would have helped had you posted the actual expression.
 

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 multiple criteria error-please help 5
dsum - 1
DSum Acting Weird 2
Dsum in Qry for total payments on an account for last 90 days 1
DSum Problem 4
dsum 9
Dsum Issues 0
DSum and date as criteria 3

Back
Top