Re: update query for multiple changes to a single field

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
    ... 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: Multiple-Attribute Keys and 1NF
    ... wire means earth" and "a yellow wire means earth". ... codes, where a color code contains one or more colors, and maybe a "thick ... Perhaps a very relevant one might be "character code". ...
    (comp.databases.theory)
  • Re: Multiple-Attribute Keys and 1NF
    ... wire means earth" and "a yellow wire means earth". ... codes, where a color code contains one or more colors, and maybe a "thick ... Perhaps a very relevant one might be "character code". ... I think that the colors, as constituents of color codes, play the same role ...
    (comp.databases.theory)
  • Re: Fiducial marker code
    ... markers and sample their area for the marker codes. ... been to come up with any successful coding scheme. ... Currently I am using a 6x6 grid and thus have 36 bits to work with. ...
    (sci.image.processing)
  • Re: 2D Plots
    ... I found what you asked about (drawing unity circle with axes intersecting at origin in middle of plot) here there are two codes you could try: ...
    (comp.soft-sys.matlab)