the Control Source property. That is where you would insert your
formula/expression:
=Trim([FirstName]) & " " & Trim([LastName])
However, Access often provides more than one way to do something. As an
alternative to the above, you can create a calculated field in your query by
inserting the following in the top row of an empty column in the Query
Designer:
FullName: Trim([FirstName]) & " " & Trim ([LastName])
Doing it this way means that the FullName control on your report is a Bound
Control - it is bound to the FullName field in your query. When you drag
this field onto the report, you do not need to do anything else to its
properties.
It's your choice as to which you prefer to use.
hth,
--
Cheryl Fischer
Law/Sys Associates
Houston, TX
cri77ers said:
Thanks for responding....but like I said, I'm a rookie.
1. Do you mean for me to create this text box on the
report or do I do that back at the query??
2. Where do I find the "control source property thingy"
you mentioned?
Please be patient with me....I really need help for this
project. Thanks!
-----Original Message-----
Create a new text box on your report named
txtFullName. In the Control
Source property insert:
=Trim([FirstName]) & " " & Trim([LastName])
If the actual Field Names in your database are not
FirstName and LastName,
just adjust the code above appropriately.
--
Cheryl Fischer
Law/Sys Associates
Houston, TX
This should be an easy answer for you experts out
there.
I want to concatinate fields in my report so the first
and last name of the customer appear together. I
think I
do this somehow with the expression builder?? I'm
just a
rookie so need help ASAP please. Thanks!
.
.