MS Access Lookup Populate -

i have started managing access db used reporting. single row has 'status' can 1 of many options selected dropdown field. when reporting, each of these ~15 statuses rolls 1 of 5 'rollup statuses' translated via excel interface. add column database table automatically populates correct 'rollup status' based on selected 'status'. not know if calculated field, lookup, etc. have minimal access knowledge.

for example:

[status]---->[rollup status] scheduled----> planning tbd---->planning scheduled---->scheduled dmm pending---->scheduled eep created---->scheduled cleanup pending---->complete complete---->complete 

if understand question correctly perhaps work...

in design mode: add new column table (which call 'total') want 'rollup statuses' , call 'rollup_status'

in sql query mode:

update total   set rollup_status = '1' [status] = '2';