Access 2007 question?

I performed a query and after that I created a report based on the query. One little problem I'm having is that in the actual column containing the data in the report, it says: "Last Name. First Initial" for example "Norris. C" However, I want it to say "Name: Last Name. First... show more I performed a query and after that I created a report based on the query. One little problem I'm having is that in the actual column containing the data in the report, it says: "Last Name. First Initial" for example "Norris. C" However, I want it to say "Name: Last Name. First Initial" (e.g. "Name: Norris. C") How do I get that "Name:" prefix next to the data. I'm running Access 2007.
1 answer 1