var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Table Field from Calculation
I'm drawing a blank after a long day. I can't remember how to update a table with a value using 3 other fields to do a calc.
Table has 4 Fields
Lets say A, B, and C are given.
I want to update the Field D to =(A/B)*C
I've done something like this before, but its been a while and I can't think right now.
The short answer is to run an UPDATE query.
BUT, do you have a good reason for violating 3NF?
Me.Geek = True
save this as a query, then write your queries against the stored query, not the table
select A, B, C, (A/B)*C as D from daTable
D is gonna be a value in a crosstab. I would have to have append the data to another table then run the crosstab if I used a query.
What I have is a unit price and a total price. I want to have a quantity added the same table by just calc total price/unit price
Last edited by Jay59; 06-14-07 at 18:20.