Create multiple reports on the one form

  • Thread starter Thread starter PeterC
  • Start date Start date
P

PeterC

Hello all,
I have a form [Orders Retail] and sub-form [Orders Retail Calulated] which
calulates totals by a query and shows an order with wholesale prices. On that
form I have a command button that creates a report called wholesale order.

I wish to produce another report with the same order information yet
changing the wholesale price to manufacture price. Both these prices are
stored in the same table. Prices are subject to a combo box called model and
type.

Thankyou
 
Hello all,
I have a form [Orders Retail] and sub-form [Orders Retail Calulated] which
calulates totals by a query and shows an order with wholesale prices. On that
form I have a command button that creates a report called wholesale order.

I wish to produce another report with the same order information yet
changing the wholesale price to manufacture price. Both these prices are
stored in the same table. Prices are subject to a combo box called model and
type.

Thankyou
Click to expand...

Base the two Reports on two different queries, one using the wholesale price
and the other using the retail price.

The Form plays no role in this - the report is based on the tables, not on the
form.
 
Back
Top