How to find the letters 'xy' in a product code

  • Thread starter Thread starter Grd
  • Start date Start date
G

Grd

Hi there,

I have a product column and sometimes I have the letter xy in the product
code which I really don't want to see in my results - there are a blib that
shouldn't be there.

I can't figure out how to remove them because they aren't always in the same
place but they are always together for eg PA8XY9OP should be PA89OP in my
results.

Could anyone help me with the formula to fix this.

Any help would be greatly appreciated

Tx

Suzanne
 
Use a calculated control in your query using the Replace function to remove
the xy:

Prod: Replace([ProductCode], "xy", "")
 
Thanks

Thats exactly what I'm looking for

s

Klatuu said:
Use a calculated control in your query using the Replace function to remove
the xy:

Prod: Replace([ProductCode], "xy", "")

--
Dave Hargis, Microsoft Access MVP


Grd said:
Hi there,

I have a product column and sometimes I have the letter xy in the product
code which I really don't want to see in my results - there are a blib that
shouldn't be there.

I can't figure out how to remove them because they aren't always in the same
place but they are always together for eg PA8XY9OP should be PA89OP in my
results.

Could anyone help me with the formula to fix this.

Any help would be greatly appreciated

Tx

Suzanne
Click to expand...
Click to expand...
 
Back
Top