Hello-
I recently modified a database at work to be able to track employee
stats in two locations. Formerly, the employees were all in Reno, Nv
that were listed in the database, now I have added a team of reps from
New York, NY. I have a field named location ID in a table
(tblEmployees). This field is a look-up to another table (tblLocation)
which has Reno and New York as the table entries.
I am in the process of changing all of my queries, forms and reports
to allow the ability to pick a location if you are running a report
that displays something like attendance or quality scores. I have a
main reports form which lists all of the reports and has a preview &
print button for each report. At the bottom of this form is the
section for parameters as needed by each report such as Employee, Date
Range, Division, and location.
My question is how to report both locations instead of picking one or
the other? Will both report if this parameter is left blank?
Also, in regards to divisions, how do I allow a user to select
multiple divisions off a drop-down or list box? If they want
attendance on sales & marketing, how is this accomplished?
I'm a bit of a novice so any help would be appreciated.
Scott