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
|
|||
|
|||
calculated data from forms to a table.
Hi!
I want to know how to store calculated data from FORMS to a TABLE. Show me or please explain the method. Thanks ors |
#2
|
|||
|
|||
calculated data from forms to a table.
|
#3
|
|||
|
|||
calculated data from forms to a table.
On Fri, 03 Mar 2006 17:30:58 GMT, "DrZilboorg via AccessMonster.com"
u19209@uwe wrote: Ok, I understand the design reasoning here; but I have a related question. I need to have Access create a quarterly financial analysis of sales which involves pro-rating a fixed overhead cost over a dynamic count of items. A single query or report will change each time the query is run. I'm thinking that if I save each report based on the query as a different report this will accomplish my needs. Would like confirmation. If there's a better way, I'm all ears. There is certainly a better way. A Report is NOT a static object. It's just a dynanmic window, a way of moving data from relational tables to paper, based on the current value of the data. Once you've printed the paper, *that* is a static object which can be put into a file cabinet (or, you can print to a file and save that file in a folder). Simply base your (single) Report on a (single) parameter query which retrieves the data that you want reported. You don't say how the query or the report will change, so I'm not sure I fully understand your question! John W. Vinson[MVP] |
#4
|
|||
|
|||
calculated data from forms to a table.
John Vinson wrote:
Hi! I want to know how to store calculated data from FORMS to a TABLE. Show me or please explain the method. Storing derived data such as this in your table accomplishes three things: it wastes disk space; it wastes time (almost any calculation will be MUCH faster than a disk fetch); and most importantly, it risks data corruption. If one of the underlying fields is subsequently edited, you will have data in your table WHICH IS WRONG, and no automatic way to detect that fact. Just redo the calculation whenever you need it, either as a calculated field in a Query or just as you're now doing it - in the control source of a Form or a Report textbox. John W. Vinson[MVP] Ok, I understand the design reasoning here; but I have a related question. I need to have Access create a quarterly financial analysis of sales which involves pro-rating a fixed overhead cost over a dynamic count of items. A single query or report will change each time the query is run. I'm thinking that if I save each report based on the query as a different report this will accomplish my needs. Would like confirmation. If there's a better way, I'm all ears. TIA, David -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...arted/200603/1 |
#5
|
|||
|
|||
calculated data from forms to a table.
John Vinson wrote:
Ok, I understand the design reasoning here; but I have a related question. [quoted text clipped - 5 lines] Would like confirmation. If there's a better way, I'm all ears. There is certainly a better way. A Report is NOT a static object. It's just a dynanmic window, a way of moving data from relational tables to paper, based on the current value of the data. Once you've printed the paper, *that* is a static object which can be put into a file cabinet (or, you can print to a file and save that file in a folder). Simply base your (single) Report on a (single) parameter query which retrieves the data that you want reported. You don't say how the query or the report will change, so I'm not sure I fully understand your question! John W. Vinson[MVP] So much for the paperless office!!! The "Dynamic Count" is the parameter which changes: Cost X / Count will resolve to a different number each time the calculation is made. (Of course, this denies the existance of inflation. Costs will change, as well, but not nearly as often) Thanks for your help. -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...arted/200603/1 |
#6
|
|||
|
|||
calculated data from forms to a table.
One way I getting rid of the paper would be to e-mail the report to yourself
then save the sent report in a folder. This is what I do with my daily reports, but I'm extremely ignorant when it comes to Access and know of no other way to save the reports, lol. DrZilboorg wrote: Ok, I understand the design reasoning here; but I have a related question. [quoted text clipped - 16 lines] John W. Vinson[MVP] So much for the paperless office!!! The "Dynamic Count" is the parameter which changes: Cost X / Count will resolve to a different number each time the calculation is made. (Of course, this denies the existance of inflation. Costs will change, as well, but not nearly as often) Thanks for your help. |
#7
|
|||
|
|||
calculated data from forms to a table.
I prefer to save such information in a PDF file so that it's very difficult
for someone to change. PDF995 makes a cheap shareware program. The next version of Office is suppose to create PDFs without any other software needed. -- Jerry Whittle Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder. "ARDS" wrote: One way I getting rid of the paper would be to e-mail the report to yourself then save the sent report in a folder. This is what I do with my daily reports, but I'm extremely ignorant when it comes to Access and know of no other way to save the reports, lol. DrZilboorg wrote: Ok, I understand the design reasoning here; but I have a related question. [quoted text clipped - 16 lines] John W. Vinson[MVP] So much for the paperless office!!! The "Dynamic Count" is the parameter which changes: Cost X / Count will resolve to a different number each time the calculation is made. (Of course, this denies the existance of inflation. Costs will change, as well, but not nearly as often) Thanks for your help. |
#8
|
|||
|
|||
calculated data from forms to a table.
On Fri, 03 Mar 2006 19:15:28 GMT, "DrZilboorg via AccessMonster.com"
u19209@uwe wrote: So much for the paperless office!!! The "Dynamic Count" is the parameter which changes: Cost X / Count will resolve to a different number each time the calculation is made. (Of course, this denies the existance of inflation. Costs will change, as well, but not nearly as often) I think you need to make a distinction between a Report and the data upon which the report is based. If you need to be able to store a history of the cost and count as of every point in time that they change, and generate a report for the Dynamic Count as of any chosen time, you can keep the data in a historical table with a date/time field. You can then create a query to select the data as of that point in time, and base a Report on that query. John W. Vinson[MVP] |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
PST file has reached maximum size | Jeff C | General Discussion | 2 | October 6th, 2005 01:35 PM |
Help again from Ken Snell (Query) | Randy | Running & Setting Up Queries | 22 | August 29th, 2005 08:15 PM |
Help with relationship plase | Rock | General Discussion | 5 | July 4th, 2005 03:54 AM |
Help with relationship plase | Rock | Database Design | 5 | July 4th, 2005 03:54 AM |
Here's a shocker | Mike Labosh | General Discussion | 2 | October 26th, 2004 05:04 PM |