update query

#1

Hello,
I have a table with a field which stored account numbers. I import
them via a text file and they show up with this format: C 1234567 0

You you help with with the criteria to update the format to show:
C12345670.

What i need is shortly to remove all blank spaces.

Thanks.

#2

use:
replace("C 1234567 0"," ","")

In the upade query you would have the field name rather than the
literal sample.

Good Luck
Ira Solomon
On 9 Aug 2003 09:27:14 -0700, jprma (AT) tin (DOT) it (Paolo) wrote:

Quote:

Hello,
I have a table with a field which stored account numbers. I import
them via a text file and they show up with this format: C 1234567 0

You you help with with the criteria to update the format to show:
C12345670.

What i need is shortly to remove all blank spaces.

Thanks.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

update query

comp.database.ms-access comp.database.ms-access

update query - 08-09-2003 , 11:27 AM

Re: update query - 08-09-2003 , 03:25 PM