Report Criteria required

[stretch66]

Hi,

Have been trying to create a report for Department Staff. The problem is that I all the staff come out on the report with the same Position and Grade. When I change Position and Grade on one of the employees all the listed employees then have that Position and Grade. I assume that I'm not getting the Criteria correct on the qry.

Would be glad of some help and have attached the test file if anyone would care to look. Select fmSel_DeptStaff choose Pier2 Loaders which will then display the report.

Thanx

 

[stretch66]

Hi,

Have been trying to create a report for Department Staff. The problem is that I all the staff come out on the report with the same Position and Grade. When I change Position and Grade on one of the employees all the listed employees then have that Position and Grade. I assume that I'm not getting the Criteria correct on the qry.

Would be glad of some help and have attached the test file if anyone would care to look. Select fmSel_DeptStaff choose Pier2 Loaders which will then display the report.

Thanx

Sorry found out that it isn't the query for the report it is actually the controls on the form as the required field in JobID is not being updated. Apparently the form is fine.

 

[jubb]

Hi,
Not exactly sure what the problem is from your post.
I have opened your DB, you have 6 staff with the same Dept Id, and 5 of them had the same Job Id which was as your report was displaying, when I changed the job id for the employees it was reflected on the report. So I could have 6 employees in one Department all with different jobs listed without changing your report at all.

Jubb.

 

[stretch66]

The problem actually came from when I copied the form and removed two controls from it which I needed for editing. This was the problem from using one form for viewing and editing. I think in future I will use two completely seperate forms.