Return oldest update date only

[Grussell07]

SELECT dbo_PRF_PROCEDURE_FEE.PRF_ID, dbo_PRF_PROCEDURE_FEE.PRF_FST_FSC_ID, dbo_PRF_PROCEDURE_FEE.PRF_FST_ADD_TS, dbo_PRF_PROCEDURE_FEE.PRF_PRC_TYPE, dbo_PRF_PROCEDURE_FEE.PRF_PRC_CD, dbo_PRF_PROCEDURE_FEE.PRF_USER_ID, dbo_PRF_PROCEDURE_FEE.PRF_FEE, dbo_PRF_PROCEDURE_FEE.PRF_FEE_RULE, dbo_PRF_PROCEDURE_FEE.PRF_FEE_PCT, dbo_PRF_PROCEDURE_FEE.PRF_FEE_UNIT_LMT INTO T_97750_FEEID_2653
FROM dbo_PRF_PROCEDURE_FEE
GROUP BY dbo_PRF_PROCEDURE_FEE.PRF_ID, dbo_PRF_PROCEDURE_FEE.PRF_FST_FSC_ID, dbo_PRF_PROCEDURE_FEE.PRF_FST_ADD_TS, dbo_PRF_PROCEDURE_FEE.PRF_PRC_TYPE, dbo_PRF_PROCEDURE_FEE.PRF_PRC_CD, dbo_PRF_PROCEDURE_FEE.PRF_USER_ID, dbo_PRF_PROCEDURE_FEE.PRF_FEE, dbo_PRF_PROCEDURE_FEE.PRF_FEE_RULE, dbo_PRF_PROCEDURE_FEE.PRF_FEE_PCT, dbo_PRF_PROCEDURE_FEE.PRF_FEE_UNIT_LMT


HAVING (((dbo_PRF_PROCEDURE_FEE.PRF_FST_FSC_ID)=2660) AND ((dbo_PRF_PROCEDURE_FEE.PRF_PRC_CD)="96121"));

PRF_ID	PRF_FST_FSC_ID	PRF_FST_ADD_TS	PRF_PRC_TYPE	PRF_PRC_CD	PRF_USER_ID	PRF_FEE	PRF_FEE_RULE	PRF_FEE_PCT	PRF_FEE_UNIT_LMT
119458393	2660	07-Oct-24	CJ	96121	GR002169	93.05	AMT	0	9999
119582530	2660	04-Nov-24	CJ	96121	GR002169	93.05	AMT	0	9999
120787040	2660	02-Dec-24	CJ	96121	GR002169	93.05	AMT	0	9999
120988025	2660	06-Jan-25	CJ	96121	GR002169	93.05	AMT	0	9999
125004602	2660	03-Feb-25	CJ	96121	GR002169	93.05	AMT	0	9999
129642456	2660	03-Mar-25	CJ	96121	GR002169	93.05	AMT	0	9999
134433590	2660	07-Apr-25	CJ	96121	GR002169	93.05	AMT	0	9999
134856124	2660	07-May-25	CJ	96121	GR002169	93.05	AMT	0	9999
135040483	2660	02-Jun-25	CJ	96121	GR002169	93.05	AMT	0	9999

[June7]

If you want entire record and only one for entire dataset, use TOP N

SELECT TOP 1 * FROM dbo_PRF_PROCEDURE_FEE WHERE ... ORDER BY PRF_FST_ADD_TS;

If you want oldest record for each group, one way is http://allenbrowne.com/subquery-01.html#TopN

If you want to build query in SQLServer or a pass-through query in Access, search topic "sqlserver query oldest record per group". When I did that, Bing Copilot offers 3 examples, 2 of which will work in Access (one is like example in referenced link).

[jojowhite]

SELECT TOP 1 * FROM 
(SELECT dbo_PRF_PROCEDURE_FEE.PRF_ID, dbo_PRF_PROCEDURE_FEE.PRF_FST_FSC_ID, dbo_PRF_PROCEDURE_FEE.PRF_FST_ADD_TS, dbo_PRF_PROCEDURE_FEE.PRF_PRC_TYPE, dbo_PRF_PROCEDURE_FEE.PRF_PRC_CD, dbo_PRF_PROCEDURE_FEE.PRF_USER_ID, dbo_PRF_PROCEDURE_FEE.PRF_FEE, dbo_PRF_PROCEDURE_FEE.PRF_FEE_RULE, dbo_PRF_PROCEDURE_FEE.PRF_FEE_PCT, dbo_PRF_PROCEDURE_FEE.PRF_FEE_UNIT_LMT INTO T_97750_FEEID_2653
FROM dbo_PRF_PROCEDURE_FEE
GROUP BY dbo_PRF_PROCEDURE_FEE.PRF_ID, dbo_PRF_PROCEDURE_FEE.PRF_FST_FSC_ID, dbo_PRF_PROCEDURE_FEE.PRF_FST_ADD_TS, dbo_PRF_PROCEDURE_FEE.PRF_PRC_TYPE, dbo_PRF_PROCEDURE_FEE.PRF_PRC_CD, dbo_PRF_PROCEDURE_FEE.PRF_USER_ID, dbo_PRF_PROCEDURE_FEE.PRF_FEE, dbo_PRF_PROCEDURE_FEE.PRF_FEE_RULE, dbo_PRF_PROCEDURE_FEE.PRF_FEE_PCT, dbo_PRF_PROCEDURE_FEE.PRF_FEE_UNIT_LMT
HAVING (((dbo_PRF_PROCEDURE_FEE.PRF_FST_FSC_ID)=2660) AND ((dbo_PRF_PROCEDURE_FEE.PRF_PRC_CD)="96121")) 
ORDER BY PRF_FST_ADD_TS DESC);

[June7]

Jojo, tried that SQL and it errors with "action query cannot be used as row source". I removed INTO T_97750_FEEID_2653 and query runs. But why a complicated SQL to return 1 record? My simpler suggestion returns same result.

However, OP title calls for OLDEST so need to sort ASCENDING.