I had a similar problem a year ago: Top 3 per group including 0 Using the same approach, this will return the latest three dates for each LoginID – you may get more than three records if there are tied dates for the same LoginID. SELECT PR1.LogInID, PR1.Score, PR1.[Date Taken] FROM Progress AS PR1 WHERE … Read more
This query … SELECT ID, A, B, C, [Key 1] AS key_field FROM tblUnpivotSource UNION ALL SELECT ID, A, B, C, [Key 2] AS key_field FROM tblUnpivotSource UNION ALL SELECT ID, A, B, C, [Key 3] AS key_field FROM tblUnpivotSource; … returns this recordset (using your sample table values as tblUnpivotSource) … ID A B … Read more
I just tested this and it works in Access 2010. Say you have a SELECT query with parameters: PARAMETERS startID Long, endID Long; SELECT Members.* FROM Members WHERE (((Members.memberID) Between [startID] And [endID])); You run that query interactively and it prompts you for [startID] and [endID]. That works, so you save that query as [MemberSubset]. … Read more