If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
MS ACCESS 2003 Report
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... |
Thread Tools | |
Display Modes | |
|
|