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