[AccessD] Query Question

Steve Schapel miscellany at mvps.org
Thu Jul 12 04:46:17 CDT 2007


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
> 
>  
> 



More information about the AccessD mailing list