V
Vicki
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
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