By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,121 Members | 1,706 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,121 IT Pros & Developers. It's quick & easy.

Combine Fields Asking Parameter

P: 2
I am trying to combine LastName, Prefix and FirstName in one field in a report. The syntax doesn't error out, but when I run the report it asks for the LastName and FirstName. If I don't put anything there, the only thing that displays is the Prefix field. Of course, putting something there causes the same LastName and FirstName to appear in all rows returned. Can someone help me?
Dec 12 '08 #1
Share this Question
Share on Google+
2 Replies


DonRayner
Expert 100+
P: 489
You need to ensure that the record source for your report includes both the LastName and FirstName fields from your underlying query or table. Then it's just a matter of using an unbound text box with its control sourse set to a formula like.

Expand|Select|Wrap|Line Numbers
  1. = [Prefix] & " " & [FirstName] & " " & [LastName]
  2.  
Of course you can arrange the field names in whatever order you want.
Dec 12 '08 #2

ADezii
Expert 5K+
P: 8,638
@DonRayner
If there is a possibility that the Prefix may contain a Null Value, then use this syntax in order to avoid a leading space:
Expand|Select|Wrap|Line Numbers
  1. = [Prefix] + " " & [FirstName] & " " & [LastName]
Dec 12 '08 #3

Post your reply

Sign in to post your reply or Sign up for a free account.