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
|
|||
|
|||
Select single record and print on report
I have a table of 'Supplier', what I would like to do is to create a 'Quotation Request' as a Report, with a single suppliers details (address etc) on it, add the bits I need a quote for by hand, and simply fax it. Much further down the development of this, ( we have alot of equipment with one or many belts, filters, bearings etc)the intention is to 'automate' the setup, so that I can create say a report 'Quotation Request' with the supplier and the bits we need overall listed.. for example, a list of belts for an annual order. I am a real newbie on this!!!! ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~View and post usenet messages directly from http://www.ExcelForum.com/ |
#2
|
|||
|
|||
Select single record and print on report
You can create a parameter query - a select query that
prompts you for the supplier. Select all the fields that you want displayed on your report. In the criteria field for the field that uniquely identifies your supplier, type something like this: [Enter Supplier] This prompt will allow you to enter the specific supplier that you want. Then, you can use report wizard to build the report based on your query. -----Original Message----- I have a table of 'Supplier', what I would like to do is to create a 'Quotation Request' as a Report, with a single suppliers details (address etc) on it, add the bits I need a quote for by hand, and simply fax it. Much further down the development of this, ( we have alot of equipment with one or many belts, filters, bearings etc)the intention is to 'automate' the setup, so that I can create say a report 'Quotation Request' with the supplier and the bits we need overall listed.. for example, a list of belts for an annual order. I am a real newbie on this!!!! ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~View and post usenet messages directly from http://www.ExcelForum.com/ . |
Thread Tools | |
Display Modes | |
|
|