By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
425,705 Members | 1,845 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 425,705 IT Pros & Developers. It's quick & easy.

Removing data in a query.

P: n/a
I want to have a query that removes all dashes between the item code,
from field named [item name]
But I don't want to delete the dashes from the table.
See 3 different examples.

Panasonic KX-TCA91 Over the Ear Headset with Mute KXTCA91
Panasonic KX-TCA92 Headset with in-line Volume Control KXTCA92-A
Sharp MRD-M500 250W x 1 Mono Subwoofer Amplifier MRDM500

I tried this code
Field: NewItemName: Replace ([Item Name] , "-","")
But I'm getting an error "Undefined function 'Replace' in expression"
I have Access 2000
What is the correct code?

Thanks
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
"Jacky11" <my*****@hotmail.com> wrote in message
news:46**************************@posting.google.c om...
I want to have a query that removes all dashes between the item code,
from field named [item name]
But I don't want to delete the dashes from the table.
See 3 different examples.

Panasonic KX-TCA91 Over the Ear Headset with Mute KXTCA91
Panasonic KX-TCA92 Headset with in-line Volume Control KXTCA92-A
Sharp MRD-M500 250W x 1 Mono Subwoofer Amplifier MRDM500

I tried this code
Field: NewItemName: Replace ([Item Name] , "-","")
But I'm getting an error "Undefined function 'Replace' in expression"
I have Access 2000
What is the correct code?


Replace() exists in Access 2000 but for some reason the expression service doesn't
pick it up so you can't use it in queries. You can create a custom function that
does nothing more than act as a wrapper for Replace() and then use that in your
query.
Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.