append two columns with into one column

  • Thread starter Thread starter sakthivel_g
  • Start date Start date
S

sakthivel_g

i need to append like the following string
Column1+0000000+Column2
how to append columns in this One in MS access kindly provide asample code
to do so
 
You should do this in a query.

Create a query and in the querygrid create a new field like this:

fieldname: field1 & 0000000 & field2

where fieldname is a name you can makeup (remember to place the : after the
fieldname because that indicates the columnheader for your field)

Field1 is the first fieldname which you want to concatenate and field2 is
the second one. Replace these with your own fieldnames you want to
concatenate..

hth
 
it is not good database practice to put more than one piece of information in
a single field. On the contrary, good database design requires you to have
no more than one piece of information in a field.

A way to deal with this, if you really need to display the [Column1] and
[Column2] values separated by 7 zeros is to create a query where you create a
computed column that contains your addition statement and assigns a field
name to it. Then lock the field or control that displays this value.

Another way to do it would be to actually change the control source of
control on your form or report to: = [Column1] + 0000000 +[Column2].
Remember to lock the control so that this value cannot be changed.

Now that I think about it, are these text values? If so, then you need to
wrap the "0000000" in quotes.

Dale
 
Back
Top