Combining columns into a field

  • Thread starter Thread starter John Searight
  • Start date Start date
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???
 
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???
 
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!
 
Back
Top