var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: update to max value of a few columns.
I have a table that looks like this:
ID, F1, F2, F3, maxval
I am trying to write an update query to update the maxval field with the max value in F1, F2, F3 for each line.
Something like this:
Update table, set maxval = max(f1,f2,f3);
Is this possible in MS Access 2007?
yeah, it's possible, but it's a very poor solution
why are F1, F2, F3 all on one row? why isn't the table normalized?
then you wouldn't have to ask how to set a max column, you'd just grab it from the table with a GROUP BY query