Single Record Report

[dichotomous]

Hi everyone.

I'm the HSE & HR Manager of an engineering company. I've built a data base with tables, forms and a modal dialogue as a switch.

All works swimmingly.

I've made tables for:

Job Tasks, which includes corresponding codes

Employees/Positions

Training

I want to generate a report that singles out:

Employeeosition:Codes (job tasks that are assigned to that position):

And I only want to print that record.

Obviously the macro builder is limited - like me on code building.

I can do stuff with wizards, but code is very very basic.

Can any of you lovely people help me??

Regards

 

[Isskint]

How do you intend to identify which Employeeosition:Code you want to report on? Input box at time of running the report or select them in a form before running the report?

 

[dichotomous]

I'm not sure whether to set up a report with the fields I want or to hve the record selected on a form.

The other thing is that there are more than one code loaded against an employee - the codes equal task descriptions and there may be 8 or nine of them.

Perhaps a report that gives me that - and that's easy enough to do. It's just how to print that out for only one employee......???

 

[Isskint]

In reports there is a setting that allows you to print each group of data seperately. So if you group on each employee that would work.

Another option would be to use a loop in VBA to go through the employees and adjust the queries SQL (QueryDefs).