Access 2007 query

[BlackGranada]

Hello if there is help at hand , I am quite new to this.. I have forms, and
tables created with 70 employees that have up to 21 different training
certifications held that all differ in dates of expiry, trying to produce one
report for all that shows each persons certification held and when due for
expiry. what is the best way for me to do this. thanks

 

[Steve]

Your tables should look like:

TblEmployee
EmployeeID
Firstname
LastName
etc

TblCert
CertID
Cert

TblEmpCert
EmpCertID
EmployeeID
CerID
CertExpireDate

Create a query tbat includes all three tables and include the fields
FirstName, LastName, Cert and CertExpireDate. Base your Report on this
query. Sort on LastName and CertExpireDate. Group on LastName.

Steve

 

[John W. Vinson]

Hello if there is help at hand , I am quite new to this.. I have forms, and
tables created with 70 employees that have up to 21 different training
certifications held that all differ in dates of expiry, trying to produce one
report for all that shows each persons certification held and when due for
expiry. what is the best way for me to do this. thanks

By creating a Query joining your appropriately normalized tables.

If you would like help doing so please post a description of your tables and
indicate how they are related. Do note that tables are *fundamental*; forms
and reports are based on the Tables, not vice versa!

 

[Rich Wonneberger]

Steve,

What would happen if you had Joe Smith, and Tom Smith.
Both with multiple certs?
If the query had both fields sorted ascending would it keep each users
certs together?

Rich W.

 

[Steve]

Yes, Joe and Tom are two different employees in TblEmployee each with
separate EmployeeIDs. Note in TblEmpCert that certs are associated with
EmployeeID so Joe's and Tom's certs would be kept separate.

Steve

 

[Rich Wonneberger]

Steve,

Thanks for the reply.
I see why they would be separate now.

 

[bigbolokbob]

hi everyone how do i find couples on here from uk

 

[Larry Linson]

This is a newsgroup for questions and answers about, or technical discussion
of, Microsoft Access database software. It is not a "friend-finder" group,
or a pen-pal group, or a swinger's group -- you'll not find any of those in
the microsoft.public... newsgroup hierarchy, which deals with Microsoft
products only.

Larry Linson
Microsoft Office Access MVP

 

[John W. Vinson]

hi everyone how do i find couples on here from uk

Well, not here on this technical support newsgroup for Microsoft Access
database software. Please look elsewhere - i.e. not on any of the Microsoft
technical newsgroups.