Hi
i have a table which records the number of cards issued to a team
fields are
Team text
Numof yellow integer
numor Red integer
date yellow short date
date red short date
query1
assigns years months and weeknumber to both date yellow and date red
query 2
returns team numof yellow total of cards based on a year ie 2005
query 3
returns team numof red total of cards based on a year ie 2005
what i want to do now is put join query2 and query3 to get a combine
result
ie Team numof yellow numof red Total
team 1 4 2 6
team 2 2 3 5
team 3 6 4 10
what i am getting is duplicate record
ie
Team numof yellow numof red Total
team 1 2 2
team 1 4 4
team 2 3 3
team 2 2 2
team 3 6 6
team 3 4 4
Can anyone please tell me how to resolve this
thanks
kevin