Hi
I am attempting to create database for my schools athletics carnival and need to be able to calculate participation points and PlacePoints then add them together, hence my two queries:
I have a query which gives me the following results: qryParticipation
House1 House2
50 60
and another query with following result: qryPlacePoints
House SumOfPoints
House1 30
House2 25
What I now want to do is create a query which will add the tally from qryParticipation and qryPlacePoints for each House.
Not sure where to begin with this problem has anyone got a suggestion?
Any thoughts appreciated.
cheers
Tanya
I am attempting to create database for my schools athletics carnival and need to be able to calculate participation points and PlacePoints then add them together, hence my two queries:
I have a query which gives me the following results: qryParticipation
House1 House2
50 60
and another query with following result: qryPlacePoints
House SumOfPoints
House1 30
House2 25
What I now want to do is create a query which will add the tally from qryParticipation and qryPlacePoints for each House.
Not sure where to begin with this problem has anyone got a suggestion?
Any thoughts appreciated.
cheers
Tanya