By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,694 Members | 2,121 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,694 IT Pros & Developers. It's quick & easy.

using location in report parameters

P: n/a
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
Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
"Scott Sabo" wrote
My question is how to report both locations
instead of picking one or the other? Will both
report if this parameter is left blank?
Assuming you are creating the SQL WHERE clause or the WhereCondition of
DoCmd.OpenReport in code, it would depend on your code -- you could
certainly code to include both if neither were specified in a TextBox on the
Form you use to select.
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?


A ListBox can be "Multi-Select", and the selected items used as described
above. Combo Boxes (aka, "drop downs") do not have this capability.

Larry Linson
Microsoft Access MVP
Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.