display in diff layout then table data (access 2000)

B

_Bigred

I have a table the contains fields for Last Name and First Name in
tblEMPLOYEE
LastName FirstName
Doe | John

But I would like to use this data on a report that would place this data in
1 field showing it in the
Doe, John format

Is there a way to do this without changing the source table's data?

TIA,
_Bigred
 
D

Duane Hookom

Add a text box to your report and set the control source to:
=[LastName] & ", " & [FirstName]
Make sure the name of the text box is not also the name of a field.
 
B

_Bigred

Thanks much Duane.

_Bigred


Duane Hookom said:
Add a text box to your report and set the control source to:
=[LastName] & ", " & [FirstName]
Make sure the name of the text box is not also the name of a field.

--
Duane Hookom
MS Access MVP


_Bigred said:
I have a table the contains fields for Last Name and First Name in
tblEMPLOYEE
LastName FirstName
Doe | John

But I would like to use this data on a report that would place this data
in 1 field showing it in the
Doe, John format

Is there a way to do this without changing the source table's data?

TIA,
_Bigred
Click to expand...
Click to expand...
 
Top