Grand Totals On Report


G

Guest

I have a billable day report that is sorted by [MonthAcquired], which has a
group header and footer. The report totals [AmtBilled] by month in the group
and report footer.
I have included in [MonthAcquired] (in addition to the 12 months) "pending"
which i do not want to inlcude in the totals of the report footer; however, i
do want a total for pending proposals in the group footer.
In the query, if i include in the [monthacquired]'s criteria <> pending then
it is not included on my report. I thought of creating a report subform for
the pending proposals, but i could not get it to work.

I know there is a way to calculate this, but i don't know. I do know that i
want to
sum([amtbilled] iif([monthacquired]<>"pending",0)) by the way, this results
in 0
i figured that this would be easier then and says the same thing as
sum([amtbilled]
iif([monthacquired]="january",iif([monthacquired]="february"....and so

Can i use the [HasData]? something like this:
iif([hasdata],[monthacquired]<>"pending") and
iif([hasdata],sum([amtbilled]),0)

Please help. I know that this is a simple question, but obviously not to me
and i could use your exptertise.
Thanks Vicki
 
Ad

Advertisements

M

Marshall Barton

Vicki said:
I have a billable day report that is sorted by [MonthAcquired], which has a
group header and footer. The report totals [AmtBilled] by month in the group
and report footer.
I have included in [MonthAcquired] (in addition to the 12 months) "pending"
which i do not want to inlcude in the totals of the report footer; however, i
do want a total for pending proposals in the group footer.
In the query, if i include in the [monthacquired]'s criteria <> pending then
it is not included on my report. I thought of creating a report subform for
the pending proposals, but i could not get it to work.

I know there is a way to calculate this, but i don't know. I do know that i
want to
sum([amtbilled] iif([monthacquired]<>"pending",0)) by the way, this results
in 0
i figured that this would be easier then and says the same thing as
sum([amtbilled]
iif([monthacquired]="january",iif([monthacquired]="february"....and so

Can i use the [HasData]? something like this:
iif([hasdata],[monthacquired]<>"pending") and
iif([hasdata],sum([amtbilled]),0)

I do not understand all of what you described, but the group
footer and report footer can calculate the total of
non-pending amounts by using a text box with an expression
like:
=Sum(IIf(monthacquired<>"pending", amtbilled, 0))
 

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