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

[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

 

[Klatuu]

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

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

 

[Grd]

Thanks

Thats exactly what I'm looking for

s

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

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

--
Dave Hargis, Microsoft Access MVP

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