Re: update query for multiple changes to a single field

Sorry, this is Ms Access, it should be:

update
service_calls
set
call_type = [call_type] & iif(len([call_type])=2,"01","001")

On Jul 6, 3:42 pm, Rick <R...@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:
hi all,
i have a access table, service_calls, which has a filed named call_type.

the call_type filed will have a 1 or 2 character code for each record in the
table.

i am looking for help to create an update query which will allow me to
change the values in the call_type column with a single pass.

example: the call type field will contain the following codes:
D, X, SH, K, 4, I, 3, PM, EM, L

i want to do a single pass update that will change the codes to :

D001, X001, SH01, K001, 4001, I001, 3001, PM01, EM01, L001

i know i can just change the criteria in the grid for each code and run the
query multiple times, but with approximated 100 codes to change that could
get boring.

i need to update about 172k records.

as always, any help will be greatly appreciated.


.

Relevant Pages

  • Re: update query for multiple changes to a single field
    ... the call_type filed will have a 1 or 2 character code for each record in the ... i want to do a single pass update that will change the codes to: ... i know i can just change the criteria in the grid for each code and run the ... query multiple times, but with approximated 100 codes to change that could ...
    (microsoft.public.access.queries)
  • Re: IF statement using numerical expression with a text result
    ... I toggled through the codes, ... "macropod" wrote: ... I have three criteria that have been tested with Pass/Fail results. ... text form fields to gather the original data but I am not using a form field ...
    (microsoft.public.word.tables)
  • Re: Mail Merge Filters
    ... One of the data columns has a code, there are about 10 different codes ... the Filter capabilities in the advance merge selection. ... a column to your Excel spreadsheet that you populate with a 1 or a O by ... contains a number of criteria that we want to use to filter the merge ...
    (microsoft.public.word.mailmerge.fields)
  • Re: COUNTIF adds1
    ... following criteria. ... have a specific ethnicity code in column C ... Also tried a number COUNTIF functions didn't work ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Query of multiple fields containing similar data
    ... You might run out of rows in the query design grid ... and you just need the Criteria under the one field. ... >I have a Table that contains 10 diagnosis fields, ... > diagnosis codes for each patient in the table. ...
    (microsoft.public.access.queries)
Loading