Automatic removes data

  • Thread starter Thread starter David
  • Start date Start date
D

David

I want to have a query that removes all dashes for a field
named "item name"
But I don't want to delete the dashes from the table.
What do I have to write in the query?
Thanks
 
What do the item names look like.
Are they all the same format such as:
1-23-456
0-98-765
In this case, try a select query with the field Item and
Expr1: Left$([Item],1) & Mid$([Item],3,2) &
Mid$([Item],6,3)

or does the format vary such as
1-23-456-7890
12-3-4567-9999
That's more complicated but it can be done.

Roxie Aho
(e-mail address removed)
http://www.usinternet.com/users/roxiea/index.htm
 
Thanks for your response.
See the item names bellow

Panasonic KX-TCA91 Over the Ear Headset with Mute KXTCA91
Panasonic KX-TCA92 Foldable Over the Head Headset with in-
line Volume Control KXTCA92-A
Alpine MRD-M500 250W x 1 Mono Subwoofer Amplifier MRDM500
-----Original Message-----
What do the item names look like.
Are they all the same format such as:
1-23-456
0-98-765
In this case, try a select query with the field Item and
Expr1: Left$([Item],1) & Mid$([Item],3,2) &
Mid$([Item],6,3)

or does the format vary such as
1-23-456-7890
12-3-4567-9999
That's more complicated but it can be done.

Roxie Aho
(e-mail address removed)
http://www.usinternet.com/users/roxiea/index.htm
-----Original Message-----
I want to have a query that removes all dashes for a field
named "item name"
But I don't want to delete the dashes from the table.
What do I have to write in the query?
Thanks

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