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

 

[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

 

[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.