Access Reporting

[Guest]

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?

 

[Rick B]

Sure. Just put a criteria in the filter upon which your report is based.

In the criteria under the "building" field, simply put...


Like * & [Enter Building Number to Report]




Leaving the prompt blank will get you all the buildings.

 

[Guest]

Thanks you for your time.. it is greatly appreciated!
I opened my report in design view, clicked view properties, changed my
report filter to YEs (from no) entered the:

Like * & [Enter Building Number to Report]

into the filter field and when I run my report I get the following error:

syntax error(missing operator) in query expression'(Like * & [Enter Building
Number to Report])'.

Any ideas?

Sure. Just put a criteria in the filter upon which your report is based.

In the criteria under the "building" field, simply put...


Like * & [Enter Building Number to Report]




Leaving the prompt blank will get you all the buildings.

--
Rick B

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?

 

[Rick B]

I did not say to put this in the filter. I said to put it in the criteria
of the query upon which your report is based.


--
Rick B

Thanks you for your time.. it is greatly appreciated!
I opened my report in design view, clicked view properties, changed my
report filter to YEs (from no) entered the:

Like * & [Enter Building Number to Report]

into the filter field and when I run my report I get the following error:

syntax error(missing operator) in query expression'(Like * & [Enter
Building
Number to Report])'.

Any ideas?

Sure. Just put a criteria in the filter upon which your report is based.

In the criteria under the "building" field, simply put...


Like * & [Enter Building Number to Report]




Leaving the prompt blank will get you all the buildings.

--
Rick B

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?

 

[Rick B]

Sorry, I DID say to put it in the filter.

I misspoke.

It should go in the query.


--
Rick B

I did not say to put this in the filter. I said to put it in the criteria
of the query upon which your report is based.


--
Rick B

Thanks you for your time.. it is greatly appreciated!
I opened my report in design view, clicked view properties, changed my
report filter to YEs (from no) entered the:

Like * & [Enter Building Number to Report]

into the filter field and when I run my report I get the following error:

syntax error(missing operator) in query expression'(Like * & [Enter
Building
Number to Report])'.

Any ideas?

Sure. Just put a criteria in the filter upon which your report is
based.

In the criteria under the "building" field, simply put...


Like * & [Enter Building Number to Report]




Leaving the prompt blank will get you all the buildings.

--
Rick B



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?

 

[John Spencer]

Also, it should read
= [Enter Building Number to Report]

OR it can read like the following, IF the building number is a text field
and you want to get any building where the characters entered match or ALL
buildings if nothing is entered

Like "*" & [Enter Building Number to Report] & "*"

Sorry, I DID say to put it in the filter.

I misspoke.

It should go in the query.


--
Rick B

I did not say to put this in the filter. I said to put it in the criteria
of the query upon which your report is based.


--
Rick B

Thanks you for your time.. it is greatly appreciated!
I opened my report in design view, clicked view properties, changed my
report filter to YEs (from no) entered the:

Like * & [Enter Building Number to Report]

into the filter field and when I run my report I get the following
error:

syntax error(missing operator) in query expression'(Like * & [Enter
Building
Number to Report])'.

Any ideas?


:

Sure. Just put a criteria in the filter upon which your report is
based.

In the criteria under the "building" field, simply put...


Like * & [Enter Building Number to Report]




Leaving the prompt blank will get you all the buildings.

--
Rick B



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?