Is there a function in a query to pull records for the most recent date of a set of records? Thanks
M Marla Sep 16, 2003 #1 Is there a function in a query to pull records for the most recent date of a set of records? Thanks
J Joe Fallon Sep 16, 2003 #2 Sure. Every query can accept Criteria. So if your data has a field like StartDate you can use criteria like: Date() Click to expand... Or: Between Date()-1 and Date() Or any other combination you want.
Sure. Every query can accept Criteria. So if your data has a field like StartDate you can use criteria like: Date() Click to expand... Or: Between Date()-1 and Date() Or any other combination you want.
