Rx_
Nothing In Moderation
- Local time
- Today, 11:46
- Joined
- Oct 22, 2009
- Messages
- 2,803
How to create a view (query) that sorts on [date Entered], then only shows the single top record (e.g the last date that a record was entered).
Created a view that shows records sorted in order of the [Date Submitted] so it sorts with the latest date on the top.
CustomerID-----Date Entered--------- Other criteria
PK Sorted Asc --Latest date sort ------filters on other fields
The query has 0 to many records for each Customer ID. The [Date Entered] is always on top.
Now, with the list above, My final View will only show the 1st record (the latest Date Entered).
Groupby such as the First, Max Top, .... don't seem to work.
Created a view that shows records sorted in order of the [Date Submitted] so it sorts with the latest date on the top.
CustomerID-----Date Entered--------- Other criteria
PK Sorted Asc --Latest date sort ------filters on other fields
The query has 0 to many records for each Customer ID. The [Date Entered] is always on top.
Now, with the list above, My final View will only show the 1st record (the latest Date Entered).
Groupby such as the First, Max Top, .... don't seem to work.