Automatic removes data

[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

 

[[MVP] S. Clark]

The query can call a custom proc(made by you) that strips the dashes, and
displays the results in the query only. This will not affect the table
data.

--
HTH,

Steve Clark, Access MVP
FMS, Inc.
Professional Solutions Group
http://www.FMSInc.com
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Is your Access database too slow?
Are you ready to upgrade to SQL Server?
Contact us for optimization and/or upsizing!
http://www.FMSInc.com/consulting
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

 

[David]

How do i do this?

-----Original Message-----
The query can call a custom proc(made by you) that strips the dashes, and
displays the results in the query only. This will not affect the table
data.

--
HTH,

Steve Clark, Access MVP
FMS, Inc.
Professional Solutions Group
http://www.FMSInc.com
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Is your Access database too slow?
Are you ready to upgrade to SQL Server?
Contact us for optimization and/or upsizing!
http://www.FMSInc.com/consulting
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-




.

 

[John Spencer (MVP)]

In Access 2002 and later you can use the replace function in the query.

Field: NewItemName: Replace([Item Name],"-","")

That should work if I correctly remember the syntax for the replace function.