DSum

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??
 
B

BruceM

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.
 
Top