My subform, called JobVacancySubForm, is based on a query and has 2 combo boxes, one to display the department and one to display the division that the job is in. I put this in the if statement because there are cases where there are more employees than positions (sometimes an employee is terminated but the db hasn't been updated yet, etc) so instead of displaying a negative number, I just want to know that there are 0 vacancies. TotalVacancy: the total number of vacancies related to this position Where MY - JobVacancy2 is a query and JobVacancyMain is the main form.ģ. TotalOccupants: the total number of employees that have this particular job as their job title calculated by Where NumberofPositions is a field in the JobVacancy table and Code is the job code on the main form (this field gets updated in the subform)Ģ. TotalPositions: Calculates the total number of positions available: The main form is informational only and displays the job code, job title, pay grade, and then there are three textboxes.ġ. Again, I was entering data into the form, and as I tabbed from one field to the next, the status bar in Access said "Calculating." and then the entire database closed.Īs mentioned before I am using a main form (JobVacancy) and subform (JobVacancySubForm).
0 kommentar(er)
