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
|
|||
|
|||
QUERY/REPORT
I have a query which pulls up records by client#. I can populate one
report based on one search. Do I have to design a report for each query by client#. Is there a way to use the same report format for each query done by client#? |
#2
|
|||
|
|||
QUERY/REPORT
You would filter the report datasource on the client #. There is more than
one way to do this. Perhaps more details on what you're doing. Bonnie http://www.dataplus-svc.com Jim wrote: I have a query which pulls up records by client#. I can populate one report based on one search. Do I have to design a report for each query by client#. Is there a way to use the same report format for each query done by client#? -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...arted/200907/1 |
#3
|
|||
|
|||
QUERY/REPORT
On Jul 28, 6:10*am, "bhicks11 via AccessMonster.com" u44327@uwe
wrote: You would filter the report datasource on the client #. *There is more than one way to do this. *Perhaps more details on what you're doing. Bonniehttp://www.dataplus-svc.com Jim wrote: I have a query which pulls up records by client#. I can populate one report based on one search. *Do I have to design a report for each query by client#. *Is there a way to use the same report format for each query done by client#? -- Message posted via AccessMonster.comhttp://www.accessmonster.com/Uwe/Forums.aspx/access-gettingstarted/20... Im not sure how to explain this more clearly but I have ran a query based on client# and I have successfully ran a report based on that query. Now I want to change the client# in the query and run another report, using the same report format. I have changed the query to the new client# but I can not populate the report based on the new client#. I will have hundreds of client#s and I wouldn't want to have to design a report for each one. |
#4
|
|||
|
|||
QUERY/REPORT
Hi Jim,
Did you base a group on the specific client number or do some other reference in the report to a particular client number? You should be able to change the underlying query and have the report work unless you have done something funky in the report. Also, why not make it a parameter query to change the client# rather than making different queries? Bonnie http://www.dataplus-svc.com Jim wrote: On Jul 28, 6:10Â*am, "bhicks11 via AccessMonster.com" u44327@uwe wrote: You would filter the report datasource on the client #. Â*There is more than one way to do this. Â*Perhaps more details on what you're doing. [quoted text clipped - 8 lines] -- Message posted via AccessMonster.comhttp://www.accessmonster.com/Uwe/Forums.aspx/access-gettingstarted/20... Im not sure how to explain this more clearly but I have ran a query based on client# and I have successfully ran a report based on that query. Now I want to change the client# in the query and run another report, using the same report format. I have changed the query to the new client# but I can not populate the report based on the new client#. I will have hundreds of client#s and I wouldn't want to have to design a report for each one. -- Message posted via http://www.accessmonster.com |
#5
|
|||
|
|||
QUERY/REPORT
On Tue, 28 Jul 2009 06:39:14 -0700 (PDT), Jim wrote:
Im not sure how to explain this more clearly but I have ran a query based on client# and I have successfully ran a report based on that query. Now I want to change the client# in the query and run another report, using the same report format. You need to use one of Access' most powerful features: a Parameter Query. Rather than using a criterion like "A123" to select client A123, you can use a criterion [Enter client number:] in square brackets. Base the report on this QUery (or change your existing report's Recordsource property to the name of this query). Now when you run the report it will prompt you to enter a client number, and report on whatever client you type in. Even better, create an unbound (nothing in its Control Source) Combo Box on a form, allowing the user to select a client ID from a list. Use =[Forms]![NameOfForm]![NameOfCombo] as the criterion. You can put a command button on the form to open the report, or open it in the combo box's AfterUpdate event. -- John W. Vinson [MVP] |
#6
|
|||
|
|||
QUERY/REPORT
Hello John - hope you're doing well.
Exactly! John W. Vinson wrote: Im not sure how to explain this more clearly but I have ran a query based on client# and I have successfully ran a report based on that query. Now I want to change the client# in the query and run another report, using the same report format. You need to use one of Access' most powerful features: a Parameter Query. Rather than using a criterion like "A123" to select client A123, you can use a criterion [Enter client number:] in square brackets. Base the report on this QUery (or change your existing report's Recordsource property to the name of this query). Now when you run the report it will prompt you to enter a client number, and report on whatever client you type in. Even better, create an unbound (nothing in its Control Source) Combo Box on a form, allowing the user to select a client ID from a list. Use =[Forms]![NameOfForm]![NameOfCombo] as the criterion. You can put a command button on the form to open the report, or open it in the combo box's AfterUpdate event. -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...arted/200907/1 |
#7
|
|||
|
|||
QUERY/REPORT
On Jul 28, 11:27*am, "bhicks11 via AccessMonster.com" u44327@uwe
wrote: Hello John - hope you're doing well. Exactly! John W. Vinson wrote: Im not sure how to explain this more clearly but I have ran a query based on client# and I have successfully ran a report based on that query. *Now I want to change the client# in the query and run another report, using the same report format. You need to use one of Access' most powerful features: a Parameter Query.. Rather than using a criterion like "A123" to select client A123, you can use a criterion [Enter client number:] in square brackets. Base the report on this QUery (or change your existing report's Recordsource property to the name of this query). Now when you run the report it will prompt you to enter a client number, and report on whatever client you type in. Even better, create an unbound (nothing in its Control Source) Combo Box on a form, allowing the user to select a client ID from a list. Use =[Forms]![NameOfForm]![NameOfCombo] as the criterion. You can put a command button on the form to open the report, or open it in the combo box's AfterUpdate event. -- Message posted via AccessMonster.comhttp://www.accessmonster.com/Uwe/Forums.aspx/access-gettingstarted/20...- Hide quoted text - - Show quoted text - Thanks for your help. The parameter query works great. PC Professor just doesn't explain everything. lol |
Thread Tools | |
Display Modes | |
|
|