A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Setting Up & Running Reports
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

make changes to report on a fly



 
 
Thread Tools Display Modes
  #1  
Old July 24th, 2007, 11:01 PM posted to microsoft.public.access.reports
bigwillno2 via AccessMonster.com
external usenet poster
 
Posts: 39
Default 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  
Old July 25th, 2007, 05:00 AM posted to microsoft.public.access.reports
Duane Hookom
external usenet poster
 
Posts: 7,177
Default 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  
Old July 25th, 2007, 04:25 PM posted to microsoft.public.access.reports
bigwillno2 via AccessMonster.com
external usenet poster
 
Posts: 39
Default 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  
Old July 25th, 2007, 05:14 PM posted to microsoft.public.access.reports
Duane Hookom
external usenet poster
 
Posts: 7,177
Default 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  
Old July 25th, 2007, 07:06 PM posted to microsoft.public.access.reports
bigwillno2 via AccessMonster.com
external usenet poster
 
Posts: 39
Default 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  
Old July 25th, 2007, 08:13 PM posted to microsoft.public.access.reports
bigwillno2 via AccessMonster.com
external usenet poster
 
Posts: 39
Default 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  
Old July 25th, 2007, 08:46 PM posted to microsoft.public.access.reports
Duane Hookom
external usenet poster
 
Posts: 7,177
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 09:18 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.