Access 2007 query BlackGranada 12/27/2008 12:25:00 AM 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

Re: Access 2007 query "Steve" <nonsense[ at ]nomsense.com> 12/27/2008 12:40:56 AM 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" <BlackGranada[ at ]discussions.microsoft.com> wrote in message news:5CC81545-A028-41C4-A689-DBE9927948DA[ at ]microsoft.com... [Quoted Text] > 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

Re: Access 2007 query John W. Vinson <jvinson[ at ]STOP_SPAM.WysardOfInfo.com> 12/27/2008 12:52:55 AM On Fri, 26 Dec 2008 16:25:00 -0800, BlackGranada <BlackGranada[ at ]discussions.microsoft.com> wrote: [Quoted Text] >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]

Re: Access 2007 query Rich Wonneberger <turtil[ at ]frontiernet.net> 12/27/2008 1:47:31 AM 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: [Quoted Text] > 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" <BlackGranada[ at ]discussions.microsoft.com> wrote in message > news:5CC81545-A028-41C4-A689-DBE9927948DA[ at ]microsoft.com... >> 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 > >

Re: Access 2007 query "Steve" <nonsense[ at ]nomsense.com> 12/27/2008 2:08:45 AM 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" <turtil[ at ]frontiernet.net> wrote in message news:OdsySU8ZJHA.5772[ at ]TK2MSFTNGP03.phx.gbl... [Quoted Text] > 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" <BlackGranada[ at ]discussions.microsoft.com> wrote in message >> news:5CC81545-A028-41C4-A689-DBE9927948DA[ at ]microsoft.com... >>> 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 >>

Re: Access 2007 query Rich Wonneberger <turtil[ at ]frontiernet.net> 12/27/2008 2:45:15 AM Steve, Thanks for the reply. I see why they would be separate now. Steve wrote: [Quoted Text] > 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 >

Re: Access 2007 query "Larry Linson" <bouncer[ at ]localhost.not> 12/29/2008 4:28:17 AM 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" <me[ at ]marcusscreentest.co.uk> wrote in message news:OwM$8sWaJHA.4684[ at ]TK2MSFTNGP03.phx.gbl... [Quoted Text] > hi everyone how do i find couples on here from uk > "BlackGranada" <BlackGranada[ at ]discussions.microsoft.com> wrote in message > news:5CC81545-A028-41C4-A689-DBE9927948DA[ at ]microsoft.com... >> 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 >

Re: Access 2007 query John W. Vinson <jvinson[ at ]STOP_SPAM.WysardOfInfo.com> 12/29/2008 4:29:39 AM On Mon, 29 Dec 2008 04:09:10 -0000, "bigbolokbob" <me[ at ]marcusscreentest.co.uk> wrote: [Quoted Text] >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]