S
Shanin
I'm having trouble getting the results I want on something. We have a staff
roster and our receptionist would like each staff's departments worked to
show up as a column on this as well. For one, most work in multiple
departments so a little refresher on how to show multiple records in one
field on a report would be helpful.
Main thing, I cannot get a query to return the results how I want. Employee
information, phone #'s, address, etc is in tblEmployees. Staff schedules are
in tblSchedule. I need the query to return just the staff's name, only once,
their number, address, and each department that they have a scheduled shift
in from tblScedule. The EmployeeID is the common field in both. I'm tried
using a sub query with SelectDistinct but am not getting just a single
employee name. Is it possible to get it return just the Department with the
Employee name only listed once?
I just need the field Department from tblSchedule.
roster and our receptionist would like each staff's departments worked to
show up as a column on this as well. For one, most work in multiple
departments so a little refresher on how to show multiple records in one
field on a report would be helpful.
Main thing, I cannot get a query to return the results how I want. Employee
information, phone #'s, address, etc is in tblEmployees. Staff schedules are
in tblSchedule. I need the query to return just the staff's name, only once,
their number, address, and each department that they have a scheduled shift
in from tblScedule. The EmployeeID is the common field in both. I'm tried
using a sub query with SelectDistinct but am not getting just a single
employee name. Is it possible to get it return just the Department with the
Employee name only listed once?
I just need the field Department from tblSchedule.