If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
make changes to report on a fly
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 |
#2
|
|||
|
|||
make changes to report on a fly
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? -- Duane Hookom Microsoft Access MVP "bigwillno2 via AccessMonster.com" wrote: 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 |
#3
|
|||
|
|||
make changes to report on a fly
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 |
#4
|
|||
|
|||
make changes to report on a 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. -- 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 |
#5
|
|||
|
|||
make changes to report on a fly
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 |
#6
|
|||
|
|||
make changes to report on a fly
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]); bigwillno2 wrote: 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. -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...ports/200707/1 |
#7
|
|||
|
|||
make changes to report on a fly
I have no idea why your query doesn't work. It may be that your query isn't
editable. -- Duane Hookom Microsoft Access MVP "bigwillno2 via AccessMonster.com" wrote: 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]); bigwillno2 wrote: 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. -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...ports/200707/1 |
Thread Tools | |
Display Modes | |
|
|