How do I modify a name list in report view?

  • Thread starter Thread starter Wayne
  • Start date Start date
W

Wayne

I am making a name list for a report. I would like to
make the report show First and Last Names of persons.
However, I do not know the expressions to make the names
appear as "John Doe". Using the wizard, the names come
up as "John Doe". How do I bring the two names
together? Could someone please tell me what expression
to use in design view to make this name list look like a
real list of names?
 
Something like this

[FirstName] & " " & [LastName] = John Doe

or

[LastName] & ", " & [FirstName] = Doe, John
 
It sounds like you are placing the two controls (fields) next to each
other. The best way is to put the names together in a query. If you are
not using a query for the source of the report, I suggest you get in the
habit, it makes a lot of things easier. Tony showed you have to put them
together in the query. It is also possible (I believe) to do the same thing
in a control (Tony may have intended for you to use a control). You can
also just place the two controls next to each other and format the text in
the right one to be "left justified" and the left one to be "right
justified."

Does any of that make sense?

Sorry if it is over your head or if it sounds like baby talk. I was not
certain of where you are on the learning curve of Access.

Good Luck
 
Back
Top