Update field Character Set used

[saswiss]

Hi,
I have a table with suppliers. The supplier name is often typed in non-latin characters - for instance Greek or Russian.

I want to update another field "CharacterSet" with either the code of the character set used or text "Latin"/"Non-Latin"

SupplierName CharacterSet
ABC Consulting Latin
Русский Текст-к-Речь Non-Latin


How can I do this - either through VBA or a query?

I use MS Access 2007

Thanks for your help!

 

[hk1]

Are you hoping this field is automatically maintained without the user changing or selecting anything? Are you hoping to loop through existing records and update all of them? Or do you just need an extra field and a combo box so the user can fill it in every time?

 

[saswiss]

Hi,
No, the table is used to run some stats - currently the CharSet field does not exist in the download, it was created by me to determine the language of the Supplier Name. I then need to update the CharSet field (created by me) to provide info to the various data owners so they will have a better overview. Also to run reports, etc. based on the entry in this field.

No one else will access the data (or change it) - this is purely for reporting, etc.