Create multiple reports on the one form

[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

 

[John W. Vinson]

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

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.

 

[Steve]

See my response to your previous post!

Steve
(e-mail address removed)