Search results

I have a table with a field of information where I need to change the contents as follows: 'emerg' = 010 'urgent' = 020 'routine' = 030 null = 040 One of my challenges is that the table is overwritten (not appended) weekly from an excel spreadsheet. I made a test query and added field...