Help removing characters

[Sean James]

Hello,

I am totally new at this database stuff. I have been searching the archives for a couple hours and confused on how to accomplish what I need to do. I saw references to using a module but I have not used that feature yet.

I am using Access 2003. I need to remove/delete " - " space dash space, "-" and "&" from a string in one field (DGName). I'm trying to do this with a make table query

DGName
P1000
P1000 - SMLS
P1000-CA (not a type error)
UD000 - C&B
V-NET

and I want it to come out like this

DGName
P1000
P1000SMLS
P1000CA
UD000CB
V-NET

Thanks
Sean

 

[FoFa]

Try this, in designer:
ColAlias: REPLACE(REPLACE([ColName]," - ",""),"&","")

 

[Sean James]

FoFa,

Thanks for helping a newb much appreciated. I have on order some Access reference books.

Sean