If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
Access 2007 query
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 |
#3
|
|||
|
|||
Access 2007 query
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] |
#4
|
|||
|
|||
Access 2007 query
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 |
#5
|
|||
|
|||
Access 2007 query
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 |
#6
|
|||
|
|||
Access 2007 query
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 |
#7
|
|||
|
|||
Access 2007 query
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 |
#8
|
|||
|
|||
Access 2007 query
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 |
#9
|
|||
|
|||
Access 2007 query
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] |
Thread Tools | |
Display Modes | |
|
|