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.

1 Answer

  • 7 years ago
    Favorite 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]".

    • Commenter avatarLogin to reply the answers
Still have questions? Get your answers by asking now.