asked on

Access 2003: Report - Group Totals

Hi EE,

Would like to group total, the number of credits appearing on each detail line....

However, in the detail processing, am setting the credits field on the report to an alpha literal
if it's value is 0.

So am concerned what the group total will total, the underlying field, or the literal.

So should i code for the group total credits something like this:

=Sum(IIf(IsNumeric([[Credits Earned]),[Credits Earned],0)

Pls advise, tx, sandra

ASKER CERTIFIED SOLUTION

Boyd (HiTechCoach) Trimmell, Microsoft Access MVP 2010-2015

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

Si Ball

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

Boyd (HiTechCoach) Trimmell, Microsoft Access MVP 2010-2015

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

mytfein

ASKER

Tx guys for writing,

truthfully, i got this idea from another EE post....

i don't understand how the Access grouping mechanism knows to do this SUM statement
with an implicit GROUP BY

Also, normally i like writing SQL bec. if feel more control but what the diff bet:
=SUM and =DSUM (btw, i notice that DSUM does have a where parameter)

pls advise, tx, s

mytfein

ASKER

Hi Guys,

thank you HiTech for teaching about the val function. Did not know about it, and it's great bec. it
works with data type double which i needed.

so i'm trying HiTech's statement of:

=Sum(IIf(IsNumeric([[Credits Earned]),Val([Credits Earned]),0)

in a control in the group footer, and when i click ok, the control source of the control does not update
to the above formula....

if you have a minute, below is the mdb, can u try iupdateing the footer control pls?

tx, s
2011-03-25-EE-sum-.zip