Quick question - Report grouping

[121854]

Can someone help me? I need to use the sorting/grouping dialog in MS Access to concatenate three fields.

When I go to the dialog box I can set up one group but don't remember how to select a second field and concatenate field 1 and field 2.

Can someone help me with the steps to accomplish this?

Thank you - Luis

 

[dhookom]

You have to use something like this in the field/expression:
=[LastName] & [FirstName]


Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]