Jtbonner86
New Member
- Joined
- Feb 23, 2016
- Messages
- 4
Hi,
I am trying to return multiple criteria based up the records with the 3 lowest date. Below is an example data set I am using.
I am trying to return multiple criteria based up the records with the 3 lowest date. Below is an example data set I am using.
Per.ID | Location | Work | Date | |||||||
1 | Leeds | stage 1 | 1/1/2015 | Location | Leeds | |||||
2 | York | stage 1 | 1/1/2015 | |||||||
3 | Leeds | stage 2 | 2/1/2015 | per.id | date | work | ||||
4 | Sheffield | stage 1 | 2/4/2015 | 1 | 1/1/2015 | Leeds |