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/

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/

.