Forum Overview :: American McGee's Honda Civic :: SQL Coders?

[quote name="TAFKAM"]I know V's a database person, anyone else? I've been busting my head against this seemingly simple problem and thought I might as well run it up a flagpole over here as well: Item=Text PRIMARY KEY 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, Q1, Q2, Q3, Q4, FULLYEAR = real 1-12 = Months I have aggregate fields Q1, Q2, Q3, Q4, FULLYEAR that I want to stick the average of the periods into for a table full of records. What's the cleanest, easiest way to do it? 1-12 are nullable. That could potentially whack out the average values for a flat (1+2+3)/3 I thought of using variables and setting them to 1 or 0 depending on if NULL, then dividing by (var1+var2+var3), but that would be seriously wasteful in a loop for all records - Resetting the variables, testing them, writing * 5 fields x *100000000 records. Am I missing something obvious? [/quote]