Combining columns into a field

J

John Searight

I have an Access table with many tables. I want some of
the information grouped. For instances, instead of having
three different text boxes for "City", "State" and "Zip",
I want to have one bound textbox that contains "City,
State and Zip". I also have it where I need to combine
first and last name. I can combine one, but I can't seem
to combine the other despite the fact that I'm using the
same method!

For instance, in the expression builder, I first select
the table that I'm using from the first column, in the
second column, I pick the the columns that I want and
include the expression "&" between the column information.
That works for one textbox. When I go to repeat those
steps for another textbox, it gives me an error in the
preview mode.

Any suggestions???
 
R

Rick B

not sure how to do it with the expression builder, but if you are creating a
form, report, or query....
create an unboud text box and enter the following (edit for your field
names)...


= [LastName] & ", " & [FirstName]

* OR *

=[FirstName] & " " & [LastName]

* OR *
=[City] & ", " & [State] & " " & [Zip]


Hope that helps,

Rick B







I have an Access table with many tables. I want some of
the information grouped. For instances, instead of having
three different text boxes for "City", "State" and "Zip",
I want to have one bound textbox that contains "City,
State and Zip". I also have it where I need to combine
first and last name. I can combine one, but I can't seem
to combine the other despite the fact that I'm using the
same method!

For instance, in the expression builder, I first select
the table that I'm using from the first column, in the
second column, I pick the the columns that I want and
include the expression "&" between the column information.
That works for one textbox. When I go to repeat those
steps for another textbox, it gives me an error in the
preview mode.

Any suggestions???
 
J

John Searight

I don't understand why that works...but it did. Thanks:)
I'm stilly really confused as to why I can do it to one
bound textbox but not to a second. Oh well...it works and
that's all I care about:) Thanks again!
 
Top