Calculating Feilds

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
 
R

Rick B

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
 
R

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
 
G

Guest

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
 
R

Rick B

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
 
C

Charlie

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


.
.
 
J

John Vinson

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

Guest

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

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.


.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top