Hey everyone.



I'm using Access 2007 and I am trying to figure out how to run a query that compares two records.

Basically my database includes ratings of movies. I want to be able to compare two peoples ratings but only on movies both users have rated.

My tables are:

Users
[ID] (PK)
[UserName]

Movies
[ID] (PK)
[MovieTitle]

Rating
[ID] (PK)
[MovieTitle]
[UserName]
[Rating]

I tried doing a crosstab query where MovieTitle was my row heading and UserName was my column heading and the Sum of Rating filled the table. But I can't figure out how to get it to only compare movies that both users have rated. Any help would be great!

Sean