Purchase order

  • Thread starter Thread starter Kutty
  • Start date Start date
K

Kutty

I am creating a purchase order in msaccess. In sub-form I have fields as
below :
serial no, description, qty, unit price, total.
Once I print I want to get all lines as per line number series per invoice.
e.g : Invoice number 1 I need to print all line numbers and Invoice 2 I need
to print all line numbers. Sometimes it will be more than 1 page. What is
the techniq of this?
 
If I understand you correctly Kutty, use the Sorting Grouping button in the
report's Design View to group by the Invoice's unique field (the Invoice
Number perhaps?). In Sorting Grouping box, choose to have a Header. Drag
your Invoice fields into this Header section (eg Date, Customer, Invoice
Number).
The Items in the the invoice will be listed in the Details section under
this this main header.
Evi
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Invoice Report 1
Invoice Report 12
Fax Individual Report via command line 1
Sum in page footer problem 0
Totals in Report Footer 1
Sub Query? 2
Mail Merge with a many-to-one report/query 1
Invoice report 7

Back
Top