Help with report and subform

  • Thread starter Thread starter wizof103
  • Start date Start date
W

wizof103

I would like to print a report with the data source as a query, based
on two tables, one of which makes up a subform. Example: When I have a
form with the subform, per that record the information about the name,
unit, date, Vendor will all appear once on the form.. When I place the
Quanity, Description, Unit size, cost, and total, because of the
subform, there may be multiple entires on tjhe later fields in one
record. Even though it is on multiple records. (In the dataview)
I need the report to look like a invoice. It is for a requisition for
at work, and I would like the report that is printed to look like this
form, with several entries in the quanity and so on fields. To lokk
like an invoice you would receive a business with multiple purchases. I
hope I have not confused to much... If I knew what this is called I
would try to look it up for myself.
Thanks in advance.
 
Open the Northwind sample database in design view. Open the Invoice report,
to see how the invoice is created from the data in the Orders and Order
Details table (along with info from Customers and Products as well.)

To help understand how these tables fit together in Northwind, choose
Relationships on the Tools menu.
 
Back
Top