RE: [AccessDevelopers] Reverse Count Records

Tue, 01 Nov 2005 10:16:29 -0800

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.
 

From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of A.D.Tejpal
Sent: Monday, October 31, 2005 11:36 PM
To: [email protected]
Subject: Re: [AccessDevelopers] Reverse Count Records

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. 

 

 

Dawn Crosier
Application Specialist
"Education Lasts a Lifetime"




Please zip all files prior to uploading to Files section.


YAHOO! GROUPS LINKS



Reply via email to