Default values in Report

S

Sam

I have a report that I will like the default values in some of the fields to
be 0. Please help
 
K

KARL DEWEY

I assume that you may have some records with null fields. Then use the Nz
function in your query.
 
S

Sam

Thanks. i am still learning. i read most of the Q &A in the forum but it
still does not work. I tried NZ([field 1l], "0") in the format but it still
does not work
 

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

Changing defauls in 2019 0
VBA Coding Help for Beginner 0
Visio 365 Change default connector arrow style 0
Newbie Help - IF Yes No Function 0
Tagging Misspell Words with "##" 0
Report Group Footer DLookUp 0
Default local file location - folder redirection slowness 0
Access 2002 change report header text 0

Top