lynnvictoria
IS-IT--Management
After choosing an activity in an activity table (yes/no) field, i want to update a field in another table with the companyID and various dollar amounts.
fishing... 20 in column one, 5 column 2.
dancing... 45 column 3
and keep this tied together based on ID.
In Excel I used select case statements. But am lost on how to even start in Access.
fishing... 20 in column one, 5 column 2.
dancing... 45 column 3
and keep this tied together based on ID.
In Excel I used select case statements. But am lost on how to even start in Access.