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

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

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 ?

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]

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

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

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 ?

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