Totals

A

administrator

Where do I place this?
-----Original Message-----
You can use the Nz() function.
Nz([FieldName],0)

--
Duane Hookom
MS Access MVP


I have a report which runs from a crosstab query. I have
a field I've added on the report which adds the five $
columns in my query. However, if there is no value in the
field, I don't get a total. I'm not very good at
programming but surely there is some IIf statement I can
make in the total field of the report that says "If empty,
add zero."

Help.
Click to expand...


.
Click to expand...
..
 

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

Unbound Calculation populates from 3 seperate fields 1
Using select and crosstab queries on one report 1
Completely Blank Report...no title, data, etc. 3
Page numbering with Merged Document and IF statements 1
A03 - count in report footer gives me #Error? 0
Summary Report 2
Showing Totals from Subreport on Main Report 5
crosstab report layout? 2

Top