Remove letter A (if present) from a query field.

  • Thread starter Thread starter jlig via AccessMonster.com
  • Start date Start date
J

jlig via AccessMonster.com

I have the following text field in my query grid:

fieldname = AID
value = svf0-12-A31 (this is an example)

(sometimes they have the A, sometimes they don't)

Question?
 
jlig said:
I have the following text field in my query grid:

fieldname = AID
value = svf0-12-A31 (this is an example)

(sometimes they have the A, sometimes they don't)

Question?
Click to expand...


Lots of ways, but we need more details about the potential
values in the AID field. Your single example could be
handled by using AIDx: Replace(AID, "A", ""), but that won't
allow for an A to occur anywhere else in the field. Maybe
you want to remove only A's that follow the second dash or
maybe the might be some B's to remove or ... ?
 
Marshall, The Replace worked fine.
Thanks,
jlig

Marshall said:
I have the following text field in my query grid:
Click to expand...
[quoted text clipped - 7 lines]
How do I create a Temporary field called AIDx without the A ?
---------------
Click to expand...

Lots of ways, but we need more details about the potential
values in the AID field. Your single example could be
handled by using AIDx: Replace(AID, "A", ""), but that won't
allow for an A to occur anywhere else in the field. Maybe
you want to remove only A's that follow the second dash or
maybe the might be some B's to remove or ... ?
Click to expand...
 
Back
Top