If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Access Reporting
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? |
#2
|
|||
|
|||
Access Reporting
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 "Jcraig713" wrote in message ... 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? |
#3
|
|||
|
|||
Access Reporting
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? "Rick B" wrote: 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 "Jcraig713" wrote in message ... 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? |
#4
|
|||
|
|||
Access Reporting
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 "Jcraig713" wrote in message ... 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? "Rick B" wrote: 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 "Jcraig713" wrote in message ... 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? |
#5
|
|||
|
|||
Access Reporting
Sorry, I DID say to put it in the filter.
I misspoke. It should go in the query. -- Rick B "Rick B" Anonymous wrote in message ... 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 "Jcraig713" wrote in message ... 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? "Rick B" wrote: 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 "Jcraig713" wrote in message ... 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? |
#6
|
|||
|
|||
Access Reporting
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] & "*" "Rick B" Anonymous wrote in message ... Sorry, I DID say to put it in the filter. I misspoke. It should go in the query. -- Rick B "Rick B" Anonymous wrote in message ... 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 "Jcraig713" wrote in message ... 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? "Rick B" wrote: 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 "Jcraig713" wrote in message ... 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? |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Access 2002 vs. 2003 | Neil | General Discussions | 51 | February 16th, 2006 10:18 PM |
The "Right" web hosting for data access pages?? | Ron Ehrlich | General Discussion | 9 | May 6th, 2005 05:49 AM |
How to get data from Analysis Services cubes into Access | General Discussion | 2 | December 4th, 2004 02:21 PM | |
Access 2000 -vs- Access 2003? | Mark | General Discussion | 5 | November 30th, 2004 06:36 AM |
is Access 2003 any better than XP? | Gorb | General Discussion | 4 | November 11th, 2004 09:44 PM |