Your file duly fixed, has been uploaded to the files
section under the name ExampleforReverseCount_Fixed.zip.
You might like to verify and confirm whether it is
OK.
----- Original Message -----
Sent: Tuesday, November 01, 2005
23:46
Subject: RE: [AccessDevelopers] Reverse
Count Records
A.D. -
Thank you for your assistance. I have uploaded a file
called "Example for Reverse Count.zip". Within it is a report called
"Royalty Interviews". It is based on a query which groups the scores of
several events into the appropriate age group of the contestant. King
& Queen being 15-18 years of age. This is not the exact report
that will break into states for further reporting, but if you can help me with
the logistics of it, then I should be able to modify my existing report.
The number of participants which enroll in the Royalty Contests are fewer in
number than those who participate in the remainder of the individual events,
therefore providing a much smaller database to work with than the 11,0000 +
members.
Thank you in advance for your assistance.
This message was
posted to a newsgroup. Please post replies and questions to the group so
that others can learn as well.
Dawn,
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.
Best wishes,
A.D.Tejpal
----- 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.
