Update table data

  • Thread starter Thread starter hoachen
  • Start date Start date
H

hoachen

I create a table that have a column name "CommissionPaid", and three options
selection from a form: 1-Yes, 2-No, and 3-NA. When the data is enter, it
automatically insert into table for, 1 or 2 or 3 (name: CommissionPaid). It
is difficult to understand after awhile what 1, 2 and 3 means after many
radio button and checkboxes. I want to make it easy to read in the future by
"Yes" or "No" or "NA" in the CommissionPaid column instead of value 1,2 or 3.
I am think using the update query and the link the field and update
automatically after the selection is selected. I have tried but unsuccessful
:( Is there any example or better solution to this?
Thank you anyone try to help
 
Perform all of your data interaction in forms where you can use a combo box
for the CommissionPaid field.
 
Thank you for your replied.

I already 90% of the fields were combo boxes. Any other suggestion?
 
-_- what you should do is in your queries when you select that value
have something like switch(1,"yes",2,"no",3,"N/A") and then it will
display like that if you want to do a mass update you can do
something like

update mytable set CommissionPaid = "yes" where CommissionPaid = 1

but to do that you will have to change the data type to text and as a
note it will most likly break your forms as well
 
sorry let me fix that syntax for the switch statement

Switch([CommissionPaid ]= 1,"yes",[CommissionPaid ]=2,"no",
[CommissionPaid ]=3,"N/A")
 
Back
Top