A
A64+
Im using a Report in MS ACCESS 2003. Ive 2 tables. One named 'Candiate_Table'
and the other named 'Votes_Table'.
'Candidate_Table' has the id of each candidates which are primary-keys.
'Vote_Table' contains votes obtained for all candidates.
My Report displays the total number of votes obtained by a candidate.
Now my problem arises. At the last page of the report i want to display the
average votes earned by a candidate. However, i can display the total no of
votes obtained by a particluar candidate with the help of 'Expression
Builder' (ie, by giving '=count(*)' ). But i cant display the average votes
obtained by a candidate.
The table 'Vote_Table' contains votes obtained by all the candidate.
So my average vote display equation should be something like this:
(total_individual_candidate_vote/total_all_candidate_vote)/100.
But how can i accomplish this.
Do ive to write subqueries?
Im a beginner.
Please give me a solution. Im running out of time.
Thnx, always
-- Sometimes, Difficult things are possible...
and the other named 'Votes_Table'.
'Candidate_Table' has the id of each candidates which are primary-keys.
'Vote_Table' contains votes obtained for all candidates.
My Report displays the total number of votes obtained by a candidate.
Now my problem arises. At the last page of the report i want to display the
average votes earned by a candidate. However, i can display the total no of
votes obtained by a particluar candidate with the help of 'Expression
Builder' (ie, by giving '=count(*)' ). But i cant display the average votes
obtained by a candidate.
The table 'Vote_Table' contains votes obtained by all the candidate.
So my average vote display equation should be something like this:
(total_individual_candidate_vote/total_all_candidate_vote)/100.
But how can i accomplish this.
Do ive to write subqueries?
Im a beginner.
Please give me a solution. Im running out of time.
Thnx, always
-- Sometimes, Difficult things are possible...