JCraig,
A simple method, among many, is t use a "parameter" query.
In the query behind your report in the BldgNo field, place a criteria
like this...
[Enter a Building Number]
When the report runs, the query will prompt the user for "Enter a
Building Number" with an Input Box. If the user enters 15 in response, the
query BldgNo will be filtered by that value, and only return records for
Building 15.
--
hth
Al Camp
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions
"Jcraig713" <(E-Mail Removed)> wrote in message
news:C7603A8D-A49B-4403-86A8-(E-Mail Removed)...
> Good Morning All! I have a question regarding a report I have built. A
> little background... I have 19 different buildings showing student
> information. This report is page breaking by building number (01-19) and
> totaling by page the number of students.
>
> I have protected the database on my network so users from all buildings
> can
> access the DB in read mode only to retrieve their own reports. The
> problem
> is that when users from different buildings access the database and run
> the
> report, they get all 19 -per building pages. I would like to put a filter
> question (if it is possible) so when users click on the report, a box
> comes
> up allowing them to enter their builiding number and only get those pages
> that apply to them. Is this possible.? CAn anyone help?
>
Similar Threads
