Are you in a position to upload a zipped copy of your db
to the files section, with some sample data? I shall try to fix it up so as
to get the desired results.
----- Original Message -----
Sent: Tuesday, November 01, 2005
04:10
Subject: [AccessDevelopers] Reverse Count
Records
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]
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.
