make changes to report on a fly

[bigwillno2 via AccessMonster.com]

Hello, can anyone direct me on how to make changes to prices on a report on
the fly.

 

[Duane Hookom]

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?

 

[bigwillno2 via AccessMonster.com]

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]

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.

 

[bigwillno2 via AccessMonster.com]

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.

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]

 

[bigwillno2 via AccessMonster.com]

this is an update query that i've created to transfer the information from
the a select query to a table......why it doesnt work...can u spot it please..
..it gives an error of too complex....

UPDATE qrAllItemsCountFXFab LEFT JOIN tblEditablePO ON qrAllItemsCountFXFab.
OrderNo = tblEditablePO.OrderNo SET tblEditablePO.OrderNo =
[qrAllItemsCountFXFab].[OrderNo], tblEditablePO.Vendor =
[qrAllItemsCountFXFab].[Vendor], tblEditablePO.qFill = [qrAllItemsCountFXFab].
[qFill], tblEditablePO.OrderQty = [qrAllItemsCountFXFab].[OrderQty],
tblEditablePO.Type = [qrAllItemsCountFXFab].[Type], tblEditablePO.Cost = DSum
("[QfillCost]*[OrderQty]","qrAllItems","[OrderNo] =" & [OrderNo]);

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.

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.

[quoted text clipped - 6 lines]

 

[Duane Hookom]

I have no idea why your query doesn't work. It may be that your query isn't
editable.
--
Duane Hookom
Microsoft Access MVP

this is an update query that i've created to transfer the information from
the a select query to a table......why it doesnt work...can u spot it please..
..it gives an error of too complex....

UPDATE qrAllItemsCountFXFab LEFT JOIN tblEditablePO ON qrAllItemsCountFXFab.
OrderNo = tblEditablePO.OrderNo SET tblEditablePO.OrderNo =
[qrAllItemsCountFXFab].[OrderNo], tblEditablePO.Vendor =
[qrAllItemsCountFXFab].[Vendor], tblEditablePO.qFill = [qrAllItemsCountFXFab].
[qFill], tblEditablePO.OrderQty = [qrAllItemsCountFXFab].[OrderQty],
tblEditablePO.Type = [qrAllItemsCountFXFab].[Type], tblEditablePO.Cost = DSum
("[QfillCost]*[OrderQty]","qrAllItems","[OrderNo] =" & [OrderNo]);

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.

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.

[quoted text clipped - 6 lines]

Hello, can anyone direct me on how to make changes to prices on a report on
the fly.