Help

[manojmkr]

Hi to All
I want to concatenate the values of 2 columns(col1 & col2) in the 3rd column(col3) internally. can it possible ? then how?
for eg.:
table is : xyz

col1 col2 col3
1991 3 19913
1991 4 19914
2000 1 20001
2000 4 20004
.....
....
...


Thanks In advance
Mano

 

[KenReay]

hi

is this in a query?

if yes, col3:[col1] & [col2]

or in code?

dim col1, col2, col3

col3 = col1 & col2

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK

 

[hermanlaksko]

Looks like a job for the ol' Crosstab query.

Go to queries, select new, select crosstab wizard .... and you should be on your way.


Herman

They say that crime doesn't pay... does that mean my job is a crime?

 

[manojmkr]

Thanks!
But i dont want in query or to write a code but it should copy internally to the col3 while entering the values for the two columns(col1 & col2).Is their any way to do that.

Thanks
manoj

 

[scottian]

in the on current event of the form:
col3 = col1 & col2

Be ALERT - Your country needs Lerts

 

[KenReay]

Hi

Are you saying you wish to store the concatinated value in the table?, if yes, why do that, you can derive it in a query why store the data twice, you are just storing up problems when (not if) it gets out of step

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK