[AccessD] Query Question

Yes, Joe, that's exactly what I was thinking.  The "subtable" would have 
these fields:
- EmployeeID
- Licence
- ExpiryDate

A more normalised data structure like this would make the type of query 
you are asking about a lot simpler.

Rergards
Steve


Joe Hecht wrote:
> I can.
> 
> tblMain
> 
> Basic Employee Info
> 
> Subtable
> 
> 
> Cert and Exp date
> 
> Is that what you are thinking?