Report Sum

[Haynesey]

I have an accounting report with several columns.

I need each column to have a total.

I have used the following but it doesn't work. I think it is because of the fact that sum of the values are blank. Is there a workround for this?:

=Sum([ColumnA])

Thanks in advance

Lee

 

[KenHigg]

Is ColumnA the name of a text box or field in the report? And you're saying some or all of the values are zero or null? If so;

=Sum(nz([ColumnA]))

May work

 

[Haynesey]

Still not working

Hi,

Have changed this but now, when you run the report, it asks what 'ColumnA' should be as a parameter.

Some of the values of columnA are blank, some say 0.00 and some have values.

Cheers

Lee

 

[KenHigg]

I'm missing something simple here. Maybe someone else will jump in....

 

[KenHigg]

Maybe do the nz() in the query instead of the report(?)

 

[Haynesey]

attachment

Hi,

Have attached the report. Unfortunately I cannot attach the table as it would make the file massive.

The field that I am struggling with is 'ColumATotal' on the bottom left of the report footer.

Thanks

Lee

 

[KenHigg]

=Sum(VisibleColumnA)

???

 

[Haynesey]

????

Hi,

Still no luck! It is really frustrating as it should be very easy.

 

[KenHigg]

Sorry it's kind of hard to decipher what all's going on in the report without the query and some data...

 

[Haynesey]

Please help...

Hi,

Have managed to cut the database down. Please can somebody help me, am really panicing about this now, it has to be done for Wednesday.

When running the report, it will ask you for two date parameters, enter 01/04/04 and 31/03/05.

Field ColumnATotal (bottom right on report) needs to sum VisibleColumnA (Just above it).

Please help - thanks in advance

Lee

 

[krberube]

I know I'm still new but is it because VisibleColumnA is UNBOUND.? Since it then sees no data, it asks what you want to SUM?

After looking at it a bit more....is all the code behind the report just for handling the null values??? if so, could you remove all that, then make ColumnA = the ItemNetCost?? if you could then you could use the NZ sum in the above responses.

Maybe?

 

[claddagh]

This worked for me

I was having the same problem for sometime, and could not work out what to do.

The way I solved this was to make the "default value" 0
If there is a "0" there is something to calculate, but if the field was just blank nothing happened.

Hope this is of some help.

Max