Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
How to get last 10 marks per name with access SQL?
Ran into a few issues upon further testing. Had to include the id in case of multiple records with same name, date, and mark. Also having problem as it does not display all 10 that meet the criteria within the date ranges. This is the code I have now... SELECT A.ID, A.NAME, A.EDATE, A.EMARK...- devbox
- Post #6
- Forum: Microsoft: Access Other topics
-
How to get last 10 marks per name with access SQL?
Yes! PHV you are a genius! This works perfectly! Thank you very much! DB- devbox
- Post #5
- Forum: Microsoft: Access Other topics
-
How to get last 10 marks per name with access SQL?
Thanks for the relpy. With setting top values to 10 it will return the top 10 of all names, and my problem is that is need 10 for each name.- devbox
- Post #3
- Forum: Microsoft: Access Other topics
-
How to get last 10 marks per name with access SQL?
Hello, I have the following query that provides the data I need from a table with name, date, and mark; however I can't seem to figure out how to limit the query output to only the last 10 marks by date per name. (The query simply gets all marks from last month and only those >=50 further than...- devbox
- Thread
- Replies: 5
- Forum: Microsoft: Access Other topics
