View Total in Form

[Mary Edwards]

Hello

I have this queries that shows the total at the bottom

I need to View the total at the bottom in a form (literally just need that number!)
Can anyone help?

Thanks

 

[theDBguy]

Hi. Have you tried changing your form into a Datasheet view? But, if you're saying you only want to see the totals, not the records, then look into the Domain functions like DSum().

 

[bastanu]

In the Form footer add a text box and set its control source to =Sum([CountOfPSED]) or whatever name you used for the control bound to that field in the Detail section of the form.

Cheers,
Vlad