Using the Sum Feature in a report

[MichaelF81]

I have the following code

=if(not isnull(lblCalc), Sum([SquareFeet] / CInt([lblCalc])),"")

I need that to be a Sum as well, but the sum is not working... Ideas?




"Adults are just obsolete children and the hell with them." - Dr. Seuss

 

[MallardVHS]

Hey MichaelF81,

Can you give a few more details when you get a chance?

For example, where exactly in your report are you trying to use the SUM function?

>>I need THAT to be a Sum as well...<<

What does THAT refer to?

Also, is this actually a VBA question (See Forum707 if so).

Good luck

Don

[green]Tis far easier to keep your duck in a row if you just have the one.[/green]