converting fieldsto other fields

H

Hans

First:
In a Database I have a field named "postkode" (7 positions text) e.g. "4100
AC"
In the same Database I also have a field named "huisnr" (5 positions
numeric) eg. number 16
Second:
In that Database I've made a new field named pcode
What I would like to have is that the field pcode looke like: "4100ac" (6
positions text)
Third:
In that same Database I've also made a new field named: "pcodehuisnr"
After the second step, I would like to have the field named: "pcodehuisnr"
contains "4100ac16"

So the contains of the excisting field "postkode" = 4100 AC (=7 positions
text)
and the contains of the excisting field "huisnr""= 16 (=5 positions numeric)
In the new situation I would like to have that the field named:
"pcodehuisnr""contains "4100ac16"

Can someody help me please to solve this problem ?
Hans.
 
D

Douglas J. Steele

To remove the space in postkode, use the Replace function:

pcode: Replace([postkode], " ", "")

pcodehuisnr: Replace([postkode], " ", "") & [huisnr]
 
Top