query from query

[Reggie2004]

I am writing a query from a query. This is the code
SELECT [Why not workable].[SSN P ], [Why not workable].TXPD, [Why not workable].[LFRZ-RFRZ], [Why not workable].[TC-150], [Why not workable].[TC-290], [Why not workable].[TC-291], [Why not workable].[TC-300], [Why not workable].[TC-301], [Why not workable].[TC-420], [Why not workable].[TC-421], [Why not workable].[TC-424], [Why not workable].[TC-530], [Why not workable].[TC-540], [Why not workable].[TC-590], [Why not workable].[TC-591], [Why not workable].[TC-594], [Why not workable].[TC-599], [Why not workable].[TC-976], [Why not workable].[TC-977], [Why not workable].[ DOB ], [Why not workable].[ DOD ]
FROM [Why not workable]
SELECT FROM Why not workale
Where TXPD = (SELECT MIN(TXPD)FROM Why not workable)
GROUP BY SSN P
HAVING SSN P >1;

What I am trying to do is this... When I have multiple years (TXPD), I want to remove the earliest one. I think I am on the right track. But I cannot get this to work.
SOME ONE ANY ONE PLEASE HELP!!!!!!!!!!!!!!!!!!!!!!!!!!

Reg

 

[dbomrrsm]

SELECT [Why not workable].[SSN P       ],
 [Why not workable].TXPD,
 [Why not workable].[LFRZ-RFRZ],
 [Why not workable].[TC-150],
 [Why not workable].[TC-290], 
[Why not workable].[TC-291], 
[Why not workable].[TC-300],
 [Why not workable].[TC-301],
 [Why not workable].[TC-420], 
[Why not workable].[TC-421], 
[Why not workable].[TC-424],
 [Why not workable].[TC-530],
 [Why not workable].[TC-540], 
[Why not workable].[TC-590], 
[Why not workable].[TC-591],
 [Why not workable].[TC-594],
 [Why not workable].[TC-599],
 [Why not workable].[TC-976],
 [Why not workable].[TC-977],
 [Why not workable].[  DOB     ],
 [Why not workable].[ DOD      ]
FROM [Why not workable]
Where TXPD = (SELECT MIN(TXPD)FROM [Why not workable])
GROUP BY [SSN P]
HAVING [SSN P] >1

[blue]DBomrrsm[/blue]

 

[Reggie2004]

The exact error I get is "You tried to execute a query that does not include the specified expression 'TXPD' as part of an aggregiate function