Recent content by joo-joo-man

Thanks jal, that works to pull the distinct number of tournaments out. I've played around a bit more but still have the same problem - whenever I add anything to count the placings it screws up the tournament count. My table structures are as follows: Player(ID, Lname, Fname, DOB, Gender...

Hi there, I'm a total beginner at SQL and Access and I'm having trouble writing a query. Hopefully somebody will steer me in the right direction and I will learn something in the process. I am working with a Chess database that tracks clubs, players, tournaments etc. I need to write a query...