5 tables each a day 1 result no dupes

[Mhypertext]

I have five tables each day of the week and they have 3 columns

Player_ID|TheoWin|ActWin|PlayDate

the problem is that each day has Player_IDs from the other days

is there a Query that would allow me to only pull the first time a Player_id shows up in that week and ignore the rest of there days played in the other 4 tables (or days).

or do i need to look at another way of doing it IE: deduping each table to other tables as follows

table1VStable2 = b Bvs table3 = c cVStable4 = d dVStable5 = totals with no dupes?

 

[namliam]

Your 5 tables should be only one... the table has the date in it, to ensure per day you can then group...

Working with this less than optimal design will get you into trouble like this....
You can try something like this though:
Union query:
Select * from Table1
Union all
Select * from Table2
...
Union all
Select * from Table5

Save this query as "qryUnion" or something
Now make a new query on top of this union to get the playerIDs and dates they played...