I still don't know what "substract the inventory materials from the POs
before they send it to thier material vendors" has to do with a report.
Reports are for displaying data in a nice format. IMHO you would either make
adjustments directly to the POs or create an adjustments table. Then report
the data that is stored in the tables.
--
Duane Hookom
Microsoft Access MVP


"bigwillno2 via AccessMonster.com" wrote:

i've built a schedule system for a bed manufacturer and what this does is,
get the bed that need to go through production line in lean way. They only
produce the orders that come to them, however, they somehow end up with left
over materials from previous productions. my system prints production tickets
as well as purchase orders for the materials needed to produce the beds. what
they asking me to do is that they want to be substract the inventory
materials from the POs before they send it to thier material vendors and this
could only be done at the end of each schedule. so i want to be able to edit
this Purchase Order before sending it to the vendors. does that explain a
little? thanks for your response.

Duane Hookom wrote:
Why would you want to make changes to a report? Why wouldn't you change
prices and then run the report to report the changed records?
Hello, can anyone direct me on how to make changes to prices on a report on
the fly.

--
Message posted via http://www.accessmonster.com