Can't Figure Out How To...

[Guest]

I have billable report which is grouped by client. Each entry is sorted by
month billed in ascending order (NOTE: I used the express: =Instr (1,
"JanFebMar...",Left([MonthBilled],3),3). Very helpful.
What I am trying to accomplish is to have the last entry, which is the
[remaining available days] in the client's group footer. For example:
[Client] UMB [Engagement] Leadership
[Consultant]: Vicki [Vicki's billable days]: 5 Vicki's available days
is a calculated box[vickisbillabledays]-[vickishrs/daysbilled]=[vickisad])
July I billed .5 days
Aug I billed 1 day
Sept I billed 1.5
Oct I billed .25
So, the [remaining avail days] for this client and consultant is 1.75 days
which i want to be bold in the client's group footer.
NOTE: the consultant's client may have several engagements so i have
included a grouping for [engagements].

FYI, i have glanced through the questions looking for something similar. I
found what i thought was similar - the answer DHookwork gave was
in the detail section
Name: txtCountGroup
Control Source: =1
Running Sum: overgroup
Visible: no

on format event of the detail section
Cancel=me.txtCountGroup>1

I tried this but i get an error and that i must creat and save the
macrogroup.macroname...

If this is what i am to use can u help me configure this to work for me.

Thanks a bunch.
Vicki

 

[Marshall Barton]

I have billable report which is grouped by client. Each entry is sorted by
month billed in ascending order (NOTE: I used the express: =Instr (1,
"JanFebMar...",Left([MonthBilled],3),3). Very helpful.
What I am trying to accomplish is to have the last entry, which is the
[remaining available days] in the client's group footer. For example:
[Client] UMB [Engagement] Leadership
[Consultant]: Vicki [Vicki's billable days]: 5 Vicki's available days
is a calculated box[vickisbillabledays]-[vickishrs/daysbilled]=[vickisad])
July I billed .5 days
Aug I billed 1 day
Sept I billed 1.5
Oct I billed .25
So, the [remaining avail days] for this client and consultant is 1.75 days
which i want to be bold in the client's group footer.
NOTE: the consultant's client may have several engagements so i have
included a grouping for [engagements].

FYI, i have glanced through the questions looking for something similar. I
found what i thought was similar - the answer DHookwork gave was
in the detail section
Name: txtCountGroup
Control Source: =1
Running Sum: overgroup
Visible: no

on format event of the detail section
Cancel=me.txtCountGroup>1

I tried this but i get an error and that i must creat and save the
macrogroup.macroname...

If this is what i am to use can u help me configure this to work for me.

It sounds line you typed that line into the OnFormat
property instead of in the Format event procedure.

I have no idea why you would want to cancel (i.e. suppress)
all the detail data except for the first line, but it
doesn't seem to agree with what you said you wanted.

I think maybe you just want to use a group footer text box
with the expression:
=[Vicki's billable days] - Sum([vickishrs/daysbilled])