Crystal Reports Question

I have a query in MS Access where I combine the First_Name and Last_Name into a field called Name.

But when I'm using Crystal Reports the Name's do not show up. I'm doing this for City, State Zip too. How can I get this to work?

Thanks in advance

Try to use original fields and concatenate them in your report using Formula fields.

formula={table1.FirstName} & " " & {table1.LastName}

That will work 100%


Cheers