Need help converting Excel to Access and retaining same data

[jojowhite]

test your database.

[jerikson]

Yes. I need to track which training events each instructor taught and then a searchable summary report so I can use that as a formal report to send to the state in order to show they have completed enough continuing education units to get recertified.

[jojowhite]

can you show a mock up report you need to send?

[jerikson]

This is something like what would be good enough. Just a Instructor Name, date, class name and hours set up in the same format as this picture with the instructor name as a header and the information in the same type of format orr something similar with the information above. I really like the format in this document. BR Fire Academy Training Log (2).zip

[mike60smart]

Hi

See Instructor Summary in attached

[jerikson]

Thank you! The report looks great, however, I would like to be able to search for the specific instructor and the specific course to be able to send to each respective instructor to be able to submit to the state versus capturing EVERYONE that has ever taught a class.

[mike60smart]

Hi

See attached

You select the Instructor and Subject and then click the Instructor Summary Button

[jojowhite]

open "instructor subject hour" form and you will see a "report" button there.
you can choose to filter the report or print it unfiltered.