Hello all,
This will be ,y first post here. I am relatively new to Access, I have the basics and will figure out whatever I have to. I am running Access 2010.
I am trying to get a query to only return the entries that sum over 2 points;
For instance;
DB where entryID/ userID/ points
DB Entries:
1 ABC 1
2 BCD 2
3 CDE 1
4 EFG 3
5 ABC 2
6 EFG 1
7 FGH 1
8 CDE 1
9 CDE 1
Would return;
1 ABC 1
5 ABC 2
3 CDE 1
8 CDE 1
9 CDE 1
4 EFG 3
6 EFG 1
So basically it is summing the total points for each user ID and the returning all entries for that user ID if the sum is over 2