reports and form

  • Thread starter Thread starter Kate
  • Start date Start date
K

Kate

I have a form which has 1 field that has a control source
"=sum(Issued)". I couldnt seem to do this in a macro because you cant
use aggregate functions. I want this field to show up on a report,
which obviously it doesnt at the moment because the value isnt saved.
How do I get around this?

Thanks
 
Put the same formula in your report.

Or, calculate it in the underlying query.
 
The same way, Kate.

Place a report control in the Detail footer with the Control Source set to
your expression.

Sprinks
 
You must log in or register to reply here.

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

Totaling An Aggregate Expression On A Report 4
Report on a form 5
adp report sum() 3
Display Report Total in Form 1
Access Access Report Works on One Machine but not Another 3
Access count a field in access report 2
Can't create a report from my query in Access 1
Access Form Refresh 1

Back
Top