D
db
hi,
I use this update query populate the [FactorRating] column in a table;
however, i'd like to use a VBA Case statement to set the full range (high,
mod high, mod low, and low) programmatically rather than chaning the values
in the WHERE clause each time.
UPDATE MergedCobbs SET MergedCobbs.FactorRating = "High"
WHERE FactorSum > 64 And FactorSum <= 96;
Thanks,
db
I use this update query populate the [FactorRating] column in a table;
however, i'd like to use a VBA Case statement to set the full range (high,
mod high, mod low, and low) programmatically rather than chaning the values
in the WHERE clause each time.
UPDATE MergedCobbs SET MergedCobbs.FactorRating = "High"
WHERE FactorSum > 64 And FactorSum <= 96;
Thanks,
db