So i have created a query and Max on the Record ID - this query stand alone works fine.
I have another query that i then bring in the above query but its not giving me the latest record
Query1:
ID
CustomerID
Install Date
EngineerNo
Query2:
Customer ID
CustomerOrderNo
CustomerInstallDate
then add the above query but its not showing last?
I have another query that i then bring in the above query but its not giving me the latest record
Query1:
ID
CustomerID
Install Date
EngineerNo
Query2:
Customer ID
CustomerOrderNo
CustomerInstallDate
then add the above query but its not showing last?