Null value form Queries

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a "sum queries" that add some values from a table. the result from
the queries is ok when it is som data in it, then it add the values ok and
return it to the raports. but when it isn't data in it its return
nothing(blank in report) not 0. I want it to return 0 not blank to the report.

what to dooooooooooo?????

My controll feald in repots is Sum5010.SumAvuke1
 

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

Null value in report 1
Active Form Report 2
Adding Null value in Access Reports 1
Cross Tab Report Vs Dynamic coulmns 0
Ignore null field in calculation 4
Access Access Report Works on One Machine but not Another 3
Access #Error & Excel Pivot 0
#Error Count 2

Back
Top