[AccessD] Edit contents of field.

Sheri:

Assuming the format is the same, I'd first create a new field to hold the
stripped product number, then use an update query and update the new field
to:

Left(fldProdNo,2) & Mid(fldProdNo,4,2) & Mid(fldProdNo,7,3) &
Right(fldProdNo,4).

I think that will work.

HTH

Rocky Smolin
Beach Access Software
http://www.e-z-mrp.com


----- Original Message ----- 
From: "Sheri Hixson" <sdhi at kalamazoo.net>
To: <accessd at databaseadvisors.com>
Sent: Sunday, August 08, 2004 6:53 PM
Subject: [AccessD] Edit contents of field.


> I'm just not getting this. I have a 30,000 record table that I've
imported.
> The first field has a product number with 4 hyphens - like 12-34-567-8888.
I
> need to take the hyphens out of these product numbers. Hopefully with a
> query. I have Access XP and need this to be simple and hopefully as easy
as
> possible. Any help would be appreciated.
>
> Dee
>
>
>
> -- 
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>