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
|
|||
|
|||
Calculating Feilds
HELp save the remainder of the hair I have not yet pulled
out.! My question is I have a form that has freight and material, and a field for total, when I use =[freight]* [material] in the control source the correct calculation appears in the field, however, can not get it to transfer over to the corresponding table, i have tried everything I know, it is not important, that the amount show on the form, must needs to be on the table, and I can not how to calculate on the table side either. Thanks Stacy |
#2
|
|||
|
|||
Calculating Feilds
Standard database procedures would didctate that calculations are never
stored in the table. You can perfomr the calculations when you need to see them on a report, query, or form. You should not store this figure in the table. Rick B "Stacy" wrote in message ... HELp save the remainder of the hair I have not yet pulled out.! My question is I have a form that has freight and material, and a field for total, when I use =[freight]* [material] in the control source the correct calculation appears in the field, however, can not get it to transfer over to the corresponding table, i have tried everything I know, it is not important, that the amount show on the form, must needs to be on the table, and I can not how to calculate on the table side either. Thanks Stacy |
#3
|
|||
|
|||
Calculating Feilds
Just as a further clarification, that would be kinda like storing four
fields... LastName FirstName LastCommaFirst FirstLast In a table. There is just no need for all four. The first two can be used to produce the others when needed. Rick B "Stacy" wrote in message ... HELp save the remainder of the hair I have not yet pulled out.! My question is I have a form that has freight and material, and a field for total, when I use =[freight]* [material] in the control source the correct calculation appears in the field, however, can not get it to transfer over to the corresponding table, i have tried everything I know, it is not important, that the amount show on the form, must needs to be on the table, and I can not how to calculate on the table side either. Thanks Stacy |
#4
|
|||
|
|||
Calculating Feilds
Thanks for your help, now how do I store it in the query,
when I use the expression in criteria,=[freight]* [mileage] it confuses the query and asks for the answer on run, I know I am doing something stupid wrong, but am stumped, all I need is the calculation to appear on the query Thanks Again -----Original Message----- Standard database procedures would didctate that calculations are never stored in the table. You can perfomr the calculations when you need to see them on a report, query, or form. You should not store this figure in the table. Rick B "Stacy" wrote in message ... HELp save the remainder of the hair I have not yet pulled out.! My question is I have a form that has freight and material, and a field for total, when I use =[freight]* [material] in the control source the correct calculation appears in the field, however, can not get it to transfer over to the corresponding table, i have tried everything I know, it is not important, that the amount show on the form, must needs to be on the table, and I can not how to calculate on the table side either. Thanks Stacy . |
#5
|
|||
|
|||
Calculating Feilds
In the query, you need to assign a new field name to it that can be used in
your reports or forms. For example, add a new column to your query. In the "Field" put something like: Total: [Freight] * [Material] You can use the field name [Total] in your reports or forms and it will pull the data. HTH Rick B "Rick B" wrote in message ... Just as a further clarification, that would be kinda like storing four fields... LastName FirstName LastCommaFirst FirstLast In a table. There is just no need for all four. The first two can be used to produce the others when needed. Rick B "Stacy" wrote in message ... HELp save the remainder of the hair I have not yet pulled out.! My question is I have a form that has freight and material, and a field for total, when I use =[freight]* [material] in the control source the correct calculation appears in the field, however, can not get it to transfer over to the corresponding table, i have tried everything I know, it is not important, that the amount show on the form, must needs to be on the table, and I can not how to calculate on the table side either. Thanks Stacy |
#6
|
|||
|
|||
Calculating Feilds
Put the calculation in a new field, perhaps next to
mileage. Charlie O'Neill -----Original Message----- Thanks for your help, now how do I store it in the query, when I use the expression in criteria,=[freight]* [mileage] it confuses the query and asks for the answer on run, I know I am doing something stupid wrong, but am stumped, all I need is the calculation to appear on the query Thanks Again -----Original Message----- Standard database procedures would didctate that calculations are never stored in the table. You can perfomr the calculations when you need to see them on a report, query, or form. You should not store this figure in the table. Rick B "Stacy" wrote in message ... HELp save the remainder of the hair I have not yet pulled out.! My question is I have a form that has freight and material, and a field for total, when I use =[freight]* [material] in the control source the correct calculation appears in the field, however, can not get it to transfer over to the corresponding table, i have tried everything I know, it is not important, that the amount show on the form, must needs to be on the table, and I can not how to calculate on the table side either. Thanks Stacy . . |
#7
|
|||
|
|||
Calculating Feilds
On Fri, 14 May 2004 11:30:07 -0700,
wrote: Thanks for your help, now how do I store it in the query, when I use the expression in criteria,=[freight]* [mileage] it confuses the query and asks for the answer on run, I know I am doing something stupid wrong, but am stumped, all I need is the calculation to appear on the query Don't put it in the *criteria* - type it in a vacant Field cell. Open the Query in design view; in the first empty column in the grid, type ShipCost: [Freight]*[Milage] in the Field row. Now when you open the Query, or base a Form or a Report on the query, you'll have a new field named ShipCost which can be searched, sorted, displayed or whatever you need. John W. Vinson[MVP] Come for live chats every Tuesday and Thursday http://go.compuserve.com/msdevapps?loc=us&access=public |
#8
|
|||
|
|||
Calculating Feilds
THANKK!!!!!!! I really appreciate it
-----Original Message----- In the query, you need to assign a new field name to it that can be used in your reports or forms. For example, add a new column to your query. In the "Field" put something like: Total: [Freight] * [Material] You can use the field name [Total] in your reports or forms and it will pull the data. HTH Rick B "Rick B" wrote in message . .. Just as a further clarification, that would be kinda like storing four fields... LastName FirstName LastCommaFirst FirstLast In a table. There is just no need for all four. The first two can be used to produce the others when needed. Rick B "Stacy" wrote in message ... HELp save the remainder of the hair I have not yet pulled out.! My question is I have a form that has freight and material, and a field for total, when I use =[freight]* [material] in the control source the correct calculation appears in the field, however, can not get it to transfer over to the corresponding table, i have tried everything I know, it is not important, that the amount show on the form, must needs to be on the table, and I can not how to calculate on the table side either. Thanks Stacy . |
#9
|
|||
|
|||
Calculating Feilds
John, Exactly what I needed! Thanks You!
-----Original Message----- On Fri, 14 May 2004 11:30:07 -0700, wrote: Thanks for your help, now how do I store it in the query, when I use the expression in criteria,=[freight]* [mileage] it confuses the query and asks for the answer on run, I know I am doing something stupid wrong, but am stumped, all I need is the calculation to appear on the query Don't put it in the *criteria* - type it in a vacant Field cell. Open the Query in design view; in the first empty column in the grid, type ShipCost: [Freight]*[Milage] in the Field row. Now when you open the Query, or base a Form or a Report on the query, you'll have a new field named ShipCost which can be searched, sorted, displayed or whatever you need. John W. Vinson[MVP] Come for live chats every Tuesday and Thursday http://go.compuserve.com/msdevapps?loc=us&access=public . |
Thread Tools | |
Display Modes | |
|
|