L
largie
Hi
I currently have 2 tables with this information:
MoviesTable:
ID - Autonumber
Title - Text[50]
Rate:
RID - Autonumber
ID - Int
Value - Int
The movie-table are filled with these entries
ID = 1, Title = "Pulp Fiction"
ID = 2, Title = "Batman begins"
ID = 3, Title = "Insomnia"
The rate-table are filled with these entries (note value are a number
between 0 and 10)
RID = 1, ID = 1, Value = 8
RID = 2, ID = 1, Value = 7
RID = 3, ID = 1, Value = 5
RID = 4, ID = 2, Value = 5
I've tried different solutions to get the sum of a movie using one
query (with a subquery) but I can't get it to work. As a result I want
this
ID = 1, Value = 20, Count = 3
ID = 2, Value = 5, Count = 1
ID = 3, Value = 0, Count = 0
Hopefully someone could help me, I'm really stuck on this little
query. I'm currently using Microsoft Access 2003.
Thank you for any help, cheers
Large
I currently have 2 tables with this information:
MoviesTable:
ID - Autonumber
Title - Text[50]
Rate:
RID - Autonumber
ID - Int
Value - Int
The movie-table are filled with these entries
ID = 1, Title = "Pulp Fiction"
ID = 2, Title = "Batman begins"
ID = 3, Title = "Insomnia"
The rate-table are filled with these entries (note value are a number
between 0 and 10)
RID = 1, ID = 1, Value = 8
RID = 2, ID = 1, Value = 7
RID = 3, ID = 1, Value = 5
RID = 4, ID = 2, Value = 5
I've tried different solutions to get the sum of a movie using one
query (with a subquery) but I can't get it to work. As a result I want
this
ID = 1, Value = 20, Count = 3
ID = 2, Value = 5, Count = 1
ID = 3, Value = 0, Count = 0
Hopefully someone could help me, I'm really stuck on this little
query. I'm currently using Microsoft Access 2003.
Thank you for any help, cheers
Large