reports make a totals row

M

Msam137

I have an access report that has the following columns cycle of
proposal property name and number of units. I have the report sorted by
cycle of proposals some of the options in cycle of proposal is leads,
proposal sent out what I want to be able to do is generate the total
number of units for all proposal leads, then generate the total number
of units for proposals sent out. Is there anyway to generate this on
the same report.

Thanks in advance.
 
B

Biz Enhancer

If I understand you question correctly you could try the following.

In the report footer, create a text box and put the following
=Sum(IIf([CycleOfProposals]="leads",[Units],0))
Or if you require a count function
=Count(IIf([CycleOfProposals]="leads",1,Null))
 
M

Msam137

So if I understand your solution correctly the first equation that you
have up there will display the number of units based on the cycle of
proposal if that is true. What I want to do is be able to continue to
add the units to previous number of units in other words create loop
that says x = number of units as long as cycle of proposals is =
"leads" then x+= next property units. I would like to have this placed
at the end of a defined section.
 

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

Top