Access 2007 query

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

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


"BlackGranada" wrote in message
...
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

On Fri, 26 Dec 2008 16:25:00 -0800, BlackGranada
wrote:

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

John W. Vinson [MVP]

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


"BlackGranada" wrote in message
...
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

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" wrote in message
...
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 wrote:
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


"BlackGranada" wrote in message
...
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,

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

Steve wrote:
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

hi everyone how do i find couples on here from uk
"BlackGranada" wrote in message
...
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

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

"bigbolokbob" wrote in message
...
hi everyone how do i find couples on here from uk
"BlackGranada" wrote in message
...
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

On Mon, 29 Dec 2008 04:09:10 -0000, "bigbolokbob"
wrote:

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

John W. Vinson [MVP]