[AccessD] Query Question

I can.

tblMain

Basic Employee Info

Subtable


Cert and Exp date

Is that what you are thinking?

Joe Hecht
jmhecht at earthlink.net

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Steve Schapel
Sent: Thursday, July 12, 2007 2:46 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Query Question

Joe,

As it stands, I think it would be a case for a User Defined Function.

But before going down that track...  Are you able to consider a change 
in your table design, so that these certification expiries are listed as 
separate records in a related table, instead of separate fields?

Regards
Steve


Joe Hecht wrote:
> I I have a table with employee's five different certifications they need
to
> work and the expiration date of these certificates.
> 
>  
> 
> It is a one to one relationship between employee and certification.
> 
>  
> 
> Professional license
> 
> Medical Cert
> 
> Dot Cert
> 
> Cpr
> 
> Drivers License
> 
>  
> 
> It is a one to one relation between the license and expiration date.
> 
>  
> 
> I need report that goes some thing this.
> 
>  
> 
> Parameter = # of days into the future to check (user entered)
> 
>  
> 
> For any expiration date in the criteria
> 
>  
> 
> Return the employee, the license that is expiring and the name of that
> license only (not all their valid licensees)
> 
>  
> 
> Or
> 
>  
> 
> If returning all the licensees bold the license that is meeting the
criteria
> and adding the employee to the report.
> 
>  
> 
> TIA
> 
>  
> 
> Joe Hecht
> 
> jmhecht at earthlink.net
> 
>  
> 
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com