Stripping away Syntax

[Tanya via AccessMonster.com]

Hi,

i'm wondering if its possible to strip away syntax for a field

what i have is some records that show WTR-123 for example but they need to
show as WTR123
trouble is the hyphen is not always in the same place ie WT-1234 for example

can this be done
thanks

Tanya

 

[Duane Hookom]

Open the table in datasheet view and select Edit->Replace and replace all
"-" with nothing within the field.

 

[Tanya via AccessMonster.com]

thanks Duane,

but this needs to be when importing the s/sheet into access so a function is
needed.

the user does not have access to the tables.

Tanya

Open the table in datasheet view and select Edit->Replace and replace all
"-" with nothing within the field.

Hi,

[quoted text clipped - 10 lines]

Tanya

 

[tina]

import your data, then run an Update query on the table, as

UPDATE TableName SET TableName.FieldName =
Replace([TableName].[FieldName],"-","");

replace TableName and FieldName with the correct table and field names, of
course.

hth

thanks Duane,

but this needs to be when importing the s/sheet into access so a function is
needed.

the user does not have access to the tables.

Tanya

Open the table in datasheet view and select Edit->Replace and replace all
"-" with nothing within the field.

Hi,

[quoted text clipped - 10 lines]

Tanya

 

[Duane Hookom]

You can run an update query against the imported records. Use the Replace()
function to replace the "-" with nothing.

--
Duane Hookom
MS Access MVP
--

thanks Duane,

but this needs to be when importing the s/sheet into access so a function
is
needed.

the user does not have access to the tables.

Tanya

Open the table in datasheet view and select Edit->Replace and replace all
"-" with nothing within the field.

Hi,

[quoted text clipped - 10 lines]

Tanya