Hi, So i have a query that i have set "Max" on the following fields to bring just back the latest records for the customer, however this is not working as its being back the latest in each field which do not match
CustomerAC
StartDate
EndDate
Order Date
would like to see results as follows
CustomerAC then show the latest StartDate and latest End date but must be > Start Date or Null and then again same for the order date
CustomerAC
StartDate
EndDate
Order Date
would like to see results as follows
CustomerAC then show the latest StartDate and latest End date but must be > Start Date or Null and then again same for the order date