General discussion

Locked

Access: Custom concatenation of fields

By bernie.wilson ·
A table in Access 2000 contains the fields [Last Name] and [First Name]. On the report form design, the basic concatentation of the field is [Last Name]&", "&[First Name]. If [Last Name] is blank, I want the report to display only [First Name] without the preceding comma. I realize this may require a VB macro or prior query. I just don't know what I need.

This conversation is currently closed to new comments.

6 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

Access: Custom concatenation of fields

by halleyc In reply to Access: Custom concatenat ...

type the following text in the control source of the field

=IIf(Len(Trim([LastName]))>0,[LastName] & "," & [FirstName],[FirstName])

Collapse -

Access: Custom concatenation of fields

by bernie.wilson In reply to Access: Custom concatenat ...

While this answer did allow me to make some changes to the data entry, I'm still looking for a way to pull the report and get what I'm seeking.

Collapse -

Access: Custom concatenation of fields

by Michael2 In reply to Access: Custom concatenat ...

=IIf([Last Name]<>' ',[First Name] & " , " & [Last Name],[First Name])

Collapse -

Access: Custom concatenation of fields

by bernie.wilson In reply to Access: Custom concatenat ...

This answer was similar to the first in that it did allow me to make some changes to the data entry. Look for a re-post of the question (perhaps by a friend of mine with some more points!)

Collapse -

Access: Custom concatenation of fields

by dmiles In reply to Access: Custom concatenat ...

Open the report in Design View
If you want to format,click report
To format an individual section,click the section selector
Click the auto format

Collapse -

Access: Custom concatenation of fields

by bernie.wilson In reply to Access: Custom concatenat ...
Back to Software Forum
6 total posts (Page 1 of 1)  

Related Discussions

Related Forums