Hi
I have a form that includes 6 fields in a column for department name. Next to each of those is a field that stores the name of a staff member in that department.
In a related query I call a module function that looks at the 6 department fields and returns the value of the last non null field. This means, in the real world, that that is the current department.
I also need to identify, in the query, where the corresponding staff name field is blank.
In a nutshell, I am wanting my query/report to identify all records that are currently in Department X but no staff assigned.
Hopefully someone on here can help?
Thanks.
I have a form that includes 6 fields in a column for department name. Next to each of those is a field that stores the name of a staff member in that department.
In a related query I call a module function that looks at the 6 department fields and returns the value of the last non null field. This means, in the real world, that that is the current department.
I also need to identify, in the query, where the corresponding staff name field is blank.
In a nutshell, I am wanting my query/report to identify all records that are currently in Department X but no staff assigned.
Hopefully someone on here can help?
Thanks.