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
|
|||
|
|||
New acces user
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 |
#2
|
|||
|
|||
New acces user
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" wrote in message news 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 |
#3
|
|||
|
|||
Access 2007 query
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 ? |
#4
|
|||
|
|||
Access 2007 query
On Sat, 27 Dec 2008 10:00:00 -0800, BlackGranada
wrote: 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] |
#5
|
|||
|
|||
New acces user
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" wrote in message news 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 |
#6
|
|||
|
|||
New acces user
This group is for MS Access the database program, Try the group
microsoft.public.outlook "Cynitha" wrote in message ... 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" wrote in message news 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 |
#7
|
|||
|
|||
Access 2007 query
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" wrote in message ... 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 ? |
#8
|
|||
|
|||
New acces user
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" wrote in message ... 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" wrote in message news 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 |
Thread Tools | |
Display Modes | |
|
|