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

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

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

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


.

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

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


.

.

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

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



.

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
.