Calculating Feilds

  • Thread starter Thread starter Stacy
  • Start date Start date
S

Stacy

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
 
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


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
 
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

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
 
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
 
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


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

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
 
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


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


.
Click to expand...
.
Click to expand...
 
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
Click to expand...

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, Exactly what I needed! Thanks You!
-----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
Click to expand...

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.


.
Click to expand...
 
Back
Top