Max Query not working

[Number11]

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?

 

[June7]

Show the SQL statements of each query.

 

[Pat Hartman]

I can't tell if the data is in one table or two tables. Assuming it is two tables and assuming query 1 is:
Select CustomerID, Max(InstallDate) as MaxInstall, EngineerNo
From your table
Group by CustomerID, EngineerNo;

you may need a left join if all the rows of query1 are not in query2
you may get "duplicates" if query1 has more than one EngineerNo for each CustomerID

But what does "not showing" mean?