Select single record and print on report

  • Thread starter Thread starter johncob
  • Start date Start date
J

johncob

I have a table of 'Supplier', what I would like to do is to create
'Quotation Request' as a Report, with a single suppliers detail
(address etc) on it, add the bits I need a quote for by hand, an
simply fax it. Much further down the development of this, ( we hav
alot of equipment with one or many belts, filters, bearings etc)th
intention is to 'automate' the setup, so that I can create say a repor
'Quotation Request' with the supplier and the bits we need overal
listed.. for example, a list of belts for an annual order. I am a rea
newbie on this!!!
 
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.
 
Back
Top