Dear experts,
Calling once more on your expertise.
I have a form that lists all employees (FrmEmployees.EmployeeID) with their job title (JobTitleID).
I want to display on the form in a separate field the total employee count of the hired employees and, if so applicable any temp seperately .
Example: we have 44 permanently employed staff, and presently 2 hired temps. So the count would be (44/2). When the temp contract(s) ended then the count would show (44).
Can anyone guide on how to approch this? VBA, concantenate two query counts?
Thanks for your help.
Best regards,
Siegfried
Calling once more on your expertise.
I have a form that lists all employees (FrmEmployees.EmployeeID) with their job title (JobTitleID).
I want to display on the form in a separate field the total employee count of the hired employees and, if so applicable any temp seperately .
Example: we have 44 permanently employed staff, and presently 2 hired temps. So the count would be (44/2). When the temp contract(s) ended then the count would show (44).
Can anyone guide on how to approch this? VBA, concantenate two query counts?
Thanks for your help.
Best regards,
Siegfried