New acces user

[BlackGranada]

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

 

[Steve]

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]

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 ?

 

[John W. Vinson]

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.

 

[Cynitha]

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.

 

[Pete D.]

This group is for MS Access the database program, Try the group
microsoft.public.outlook

 

[Steve]

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

 

[Arvin Meyer [MVP]]

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.