A.D. -
A while back you gave me
instructions for how I can reverse count the records returned in a report.
That has been working great, but now I have been asked to group the records by
state and show the reversed count by state. (The report is used for
reporting the winners of several contests, and is used in a script, so that the
MC for the evening properly calls for the recipient of the prize. 5th
Place, 4th Place, 3rd Place, 2nd Place, Winner, if some states only had just a
couple of participants, then the results should be 2nd Place, Winner or some
variation on that theme.)
You had me create an
unbound textbox in my Report Header called txtTotRec. Then in the format
event of the report header, I have the following code: txtTotRec =
dcount("*", me.recordsource) This tallies up the number of records in the
query which is used as the control source of the report.
You then suggested that I
place a hidden text box named txtCount, which has an _expression_ of =1 in the
detail section. In my first report, I set the running sum property to
overall. (I have also experimented with setting it to over group with no
success)
The reverse count is
displayed in a text box call txtRevCount located in the detail section.
The control source of that text box is :
=[txtTotRec] + 1-[txtCount]
=[txtTotRec] + 1-[txtCount]
It seems to me that I need
to adjust how txtTotRec gets its information, but I am not sure how to adjust
the process. Therefore, If you have any suggestions for me, I would
greatly appreciate your thoughts.
Please zip all files prior to uploading to Files section.
SPONSORED LINKS
| Microsoft access developer | Microsoft access help | Microsoft access database |
| Microsoft access training | Microsoft access programming | Microsoft access tutorial |
YAHOO! GROUPS LINKS
- Visit your group "AccessDevelopers" on the web.
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
