Return All Records If...

[skoutr1]

I have a MS Access database with a table that includes the following fields: [numID] and [numYear].

In a query, I want to return ALL records for [numID] if at least one record for [numID] has [numYear] = Year(Now()).

-Rod

 

[Remou]

How about something like:

[tt]Select * From tblTable
Where NumID In
(Select NumID From tblTable A
Where A.NumYear = Year(Date())[/tt]

 

[skoutr1]

I had people here at work giving me the same code. After much frustration and trial and error, I got it to work.

Thanks!
-Rod