displaying percentages on a report.

[ljscott]

This is what I have:
a part of a database that I have is keeping track of the number of points that a member of club has.

I want to create a report that will displays the members name, their member ID, their total points, and a number that shows how many points they have as a perecentage of the total points possible. Everthing is working except for the % part. I can't figure out how to do it.

This is basically what I have so far, that relates to this problem:

Member_Info: shows basic info about each member, assigns their ID number.

Points table: contains what each member 'scores' each week.
includes scores for 'perfect club1 member' and 'perfect club2 member,' which represent the best possible score for the two different groups involved.

points total: sums the points for each individual member.

I'm not sure how to get access to take what each member has for points and divide it by what a perfect score is. I created a separate table to just represent what the perfect score is, then divide those two, but that doesn't seem to be working either. All of this is also complicated because their are two groups, so depending on which group a person is from, they have a different possibitly for the best possible score.

as always, thanks for you help everyone.

-L

 

[dhookom]

Could you share some:
1) table structures
2) sample data
3) what you would expect to see in the report based on your sample data

Duane
MS Access MVP
Find out how to get great answers faq219-2884.

 

[ljscott]

Hello, thanks for taking a look at my question.

I started typing everything out that you asked for, but decided that it would be easiest to use screen shots. if this is ok, please take a look here:

http://lyndon.artist-ink.com/access/

thanks for your help again - i really apreciate it.

______

http://www.artist-ink.com

 

[ljscott]

anyone have any ideas?


Table Relationships

Table Structure: Member Record
keeps track of members personal info

Table: Points
keeps track of point scored each week

Query: Total Points
adds points up scored by each member.
number calculated here are used in following report

Report: Summary of Points
Report created to show members names, sum of their points.
needs to show sum of points as a percentage of possible points. the possible points are represented by the perfect scores at the top

Form: Member Record
Form used to enter info
would like to add percentage of total points to this also

Thanks for your help!



______

http://www.artist-ink.com

 

[dhookom]

I don't see any of this [red]includes scores for 'perfect club1 member' and 'perfect club2 member,' which represent the best possible score for the two different groups involved[/red].

How/where is the perfect score(s) stored?

Duane
MS Access MVP
Find out how to get great answers faq219-2884.

 

[ljscott]

perfect scores are shown by "Perfect, Pathfinder" and "Perfect, Navigator." They are stored in the Members Record table as members, which is shown in image 2. Image 5 (Form: Member Record ) shows the record for Perfect (last name), Pathfinder (first name), image 4 shows them as also.

I was thinking that maybe these two values needed to be set up in a separate table by themselves, but wasn't sure how to do it, especially when there are two different possible perfect scores, depending on what group a memeber belongs to.

Thanks again for your help.



btw.. in case you were wondering exactly what this is being used for and what "pathfinder" and "navigator" were, it is being used by a club at a church that my girlfriends sister runs. from my understanding, it is like boy scouts or girl scouts. i didn't actually design the database, but am trying to help them work out the bugs.

______

http://www.artist-ink.com