New acces user BlackGranada 12/27/2008 3:07:00 PM Help please newbie to this ..I have set up a table & form within access Trying to produce a report that shows up to 70 employees that are assigned up to 21 different training certificates with expiry date. How do i produce a query that shows all employees and training certs that may be due for re-training within 3 months ? I would like this to show on 1 report. Thanks

Re: New acces user "Steve" <nonsense[ at ]nomsense.com> 12/27/2008 4:50:13 PM You need the following tables: TblEmployee EmployeeID FirstName LastName etc TblCert CertID Cert TblEmployeeCert EmployeeCertID EmployeeID CertID ExpirationDate Create a query that includes all three tables. Include the fields: FirstName LastName Cert ExpirationDate Put the following expression in the criteria for ExpirationDate: <=Date() + 90 where 3 months is equivalent to 90 days Use the query as the recordsource for your report. Sort on LastName and ExpirationDate. Group on Lastame. Steve "BlackGranada" <BlackGranada[ at ]discussions.microsoft.com> wrote in message news:D5BABAE0-ADF1-4803-A48B-64175B55CDFD[ at ]microsoft.com... [Quoted Text] > Help please newbie to this ..I have set up a table & form within access > Trying to produce a report that shows up to 70 employees that are > assigned > up to 21 different training certificates with expiry date. > How do i produce a query that shows all employees and training certs > that > may be due for re-training within 3 months ? I would like this to show on > 1 > report. Thanks

Access 2007 query BlackGranada 12/27/2008 6:00:00 PM Thanks for the reply steve, how do i enter the certs in the table if i have 21 all with different dates that relate to each employee...do i use 1 table and 21 fields also I aready have a table with all the data which is imputted from the form..how does the data link with these new tables ?

Re: Access 2007 query John W. Vinson <jvinson[ at ]STOP_SPAM.WysardOfInfo.com> 12/27/2008 6:24:33 PM On Sat, 27 Dec 2008 10:00:00 -0800, BlackGranada <BlackGranada[ at ]discussions.microsoft.com> wrote: [Quoted Text] >Thanks for the reply steve, how do i enter the certs in the table if i have >21 all with different dates that relate to each employee...do i use 1 table >and 21 fields also I aready have a table with all the data which is imputted >from the form..how does the data link with these new tables ? "Fields are expensive, records are cheap". Reread Steve's suggestion - he has THREE tables. You would enter 21 *records* (not fields) in his suggested TblEmpCert, each with its date; you'ld use a Subform bound to TblEmpCert, using the employee ID as the subform's master/child link field. -- John W. Vinson [MVP]

Re: New acces user "Cynitha" <cynthia.zheng[ at ]sbcglobal.net> 12/27/2008 7:23:55 PM Hi, I am not here to answer your questions. I don't have the ability to do so. I am here to ask if you know who I should write to in order to ask such question: I am used to Microsoft Office Outlook, what is the difference between Window Mail, Outlook vs Outlook Express? What is the advantages and disadvantages between all 3 of them? If I were to purchase an iphone, what program does iphone sycns with? Please advice. Kindly. "BlackGranada" <BlackGranada[ at ]discussions.microsoft.com> wrote in message news:D5BABAE0-ADF1-4803-A48B-64175B55CDFD[ at ]microsoft.com... [Quoted Text] > Help please newbie to this ..I have set up a table & form within access > Trying to produce a report that shows up to 70 employees that are > assigned > up to 21 different training certificates with expiry date. > How do i produce a query that shows all employees and training certs > that > may be due for re-training within 3 months ? I would like this to show on > 1 > report. Thanks

Re: New acces user "Pete D." <pduffy211AT[ at ]coxDOT.net> 12/27/2008 10:29:07 PM This group is for MS Access the database program, Try the group microsoft.public.outlook "Cynitha" <cynthia.zheng[ at ]sbcglobal.net> wrote in message news:%23C6rqiFaJHA.5420[ at ]TK2MSFTNGP04.phx.gbl... [Quoted Text] > Hi, I am not here to answer your questions. I don't have the ability to do > so. I am here to ask if you know who I should write to in order to ask > such question: I am used to Microsoft Office Outlook, what is the > difference between Window Mail, Outlook vs Outlook Express? What is the > advantages and disadvantages between all 3 of them? If I were to purchase > an iphone, what program does iphone sycns with? > > Please advice. Kindly. > > > "BlackGranada" <BlackGranada[ at ]discussions.microsoft.com> wrote in message > news:D5BABAE0-ADF1-4803-A48B-64175B55CDFD[ at ]microsoft.com... >> Help please newbie to this ..I have set up a table & form within access >> Trying to produce a report that shows up to 70 employees that are >> assigned >> up to 21 different training certificates with expiry date. >> How do i produce a query that shows all employees and training certs >> that >> may be due for re-training within 3 months ? I would like this to show on >> 1 >> report. Thanks >

Re: Access 2007 query "Steve" <nonsense[ at ]nomsense.com> 12/28/2008 12:49:43 AM You would use a form/subform. The main form would be based on TblEmployee and the subform would be based on TblEmployeeCert. Make the subform a continuous form and you will be able to create a list of certs with each one's expiration date for each employee. You could also add a search feature to the main form to find a specific employee. Steve "BlackGranada" <BlackGranada[ at ]discussions.microsoft.com> wrote in message news:AA69335A-DB87-469C-AFD8-7FA902FAA4CC[ at ]microsoft.com... [Quoted Text] > Thanks for the reply steve, how do i enter the certs in the table if i > have > 21 all with different dates that relate to each employee...do i use 1 > table > and 21 fields also I aready have a table with all the data which is > imputted > from the form..how does the data link with these new tables ?

Re: New acces user "Arvin Meyer [MVP]" <arvinm[ at ]mvps.invalid> 12/28/2008 4:22:53 AM The iPhone only syncs with Microsoft Outlook. As to the advantages and disadvantages, you would have to ask in each of their respective newsgroups to get an accurate idea. This newsgroup is dedicated to the Microsoft Access database product. -- Arvin Meyer, MCP, MVP http://www.datastrat.com http://www.mvps.org/access http://www.accessmvp.com "Cynitha" <cynthia.zheng[ at ]sbcglobal.net> wrote in message news:%23C6rqiFaJHA.5420[ at ]TK2MSFTNGP04.phx.gbl... [Quoted Text] > Hi, I am not here to answer your questions. I don't have the ability to do > so. I am here to ask if you know who I should write to in order to ask > such question: I am used to Microsoft Office Outlook, what is the > difference between Window Mail, Outlook vs Outlook Express? What is the > advantages and disadvantages between all 3 of them? If I were to purchase > an iphone, what program does iphone sycns with? > > Please advice. Kindly. > > > "BlackGranada" <BlackGranada[ at ]discussions.microsoft.com> wrote in message > news:D5BABAE0-ADF1-4803-A48B-64175B55CDFD[ at ]microsoft.com... >> Help please newbie to this ..I have set up a table & form within access >> Trying to produce a report that shows up to 70 employees that are >> assigned >> up to 21 different training certificates with expiry date. >> How do i produce a query that shows all employees and training certs >> that >> may be due for re-training within 3 months ? I would like this to show on >> 1 >> report. Thanks >