Jamie;
This works:
FullName: [FirstName] & " " & [MI] & " " & [LastName]
You will need to modify the Field names, (those within brackets) to match
your field names, (FullName: [FName] & " " & [MName] & " " & [LName].
If your report is based on a query insert a new column and place the
expression above in that column.
Note: FullName: [FirstName] & " " & [MI] & " " & [LastName] requires that
you include the needed fields in the query.
A slight modification allows you to exclude those field names from your
query.
FullName: [tblName]![DescFirstName] & " " & [tblName]![DescLastName] & " " &
[tblName]![DescSuffix]
Modify "tblName" with the name of the table your using.
You can also use FullName: [FirstName] & " " & [MI] & " " & [LastName] in a
Report.
Drag the fields containg the First, Middle and Last names into the report.
Set their Visible properties to No Insert a Text Control and in the
Properties Control soure use:
=FullName: [FirstName] & " " & [MI] & " " & [LastName], (again modify as
needed).
Know this works. Hope I explained it clearly.
Andy
