Sounds like a plan...what should i do, create a update query that would
update the information in this new table with the information in the query
(query that contains the information that the report has) by a click of a
button or it's there a way i could edit the information on this query on the
fly.

Duane Hookom wrote:
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.
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
[quoted text clipped - 11 lines]
Hello, can anyone direct me on how to make changes to prices on a report on
the fly.

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ports/200707/1