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 Initial" (e.g. "Name: Norris. C") How do I get that "Name:" prefix next to the data. I'm running Access 2007.
- mmarreroLv 67 years agoFavorite Answer
On a query you can create your own fields: in designer it's like "FullName : [Field] & [Field2]", in SQL text it's " [Field1] & [Field2] AS Fullname ". You can also create report fields, just add a textbox, use something like "= [Field1] & [Field2]".