Sorry but i am not following you. I created a query with Custcnt with a few columns. I then create a sub inner query with the same table Custcnt. I join the top level query with the inner query.
i then check off the group by connum field in the inner query display columns and create a cal field on the inner query with the min of the connum field?
Here are my screenshots , starting from scratch
with the phrase
select
[CustCnt].[Company] as [CustCnt_Company],
[CustCnt].[CustNum] as [CustCnt_CustNum],
[CustCnt].[ConNum] as [CustCnt_ConNum],
[CustCnt].[Name] as [CustCnt_Name],
[CustCnt].[PhoneNum] as [CustCnt_PhoneNum]
from Erp.CustCnt as CustCnt
Now i am going to create subquery of the same table CustCnt
Now i am going to join the queries
am i on the right track?
Thank you