Search results

More info as requested Thanks for your response. Bear with me if I don't get all of the Access terminology correct. More Info: The field in question is the "priority" field. My report has to show the workorders sorted in "priority" order. The order of the priorities is Emerg, Urgent, and...

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...