CaseNumber MinOfDueDate Flag ddid
04229.00.0197 5/21/2016 False 290051
04229.00.0197 5/18/2016 False 290052
I am running a query that groups on the casenumber and gets the minimum date where flag is false but I need the ID included and I cannot do this because the group by instruction on that field causes both records to show. Is there a way to handle this in access. I can't use first or last because the date and ddid order are not in chron order.
HELP!
Thanks
JW
04229.00.0197 5/21/2016 False 290051
04229.00.0197 5/18/2016 False 290052
I am running a query that groups on the casenumber and gets the minimum date where flag is false but I need the ID included and I cannot do this because the group by instruction on that field causes both records to show. Is there a way to handle this in access. I can't use first or last because the date and ddid order are not in chron order.
HELP!
Thanks
JW
Comment