Crosstab query with dupl values in row question

[Tim 9000]

I'm using a crosstab query, which requires me to GroupBy Row and Column
headings.

For the Row headings, I want the field 'Name', which unfortunately contain
duplicate values.

So I must GroupBy NameID instead. This gives me the proper grouping, except
I lose the literal 'Name's, and I want them back.

What approaches can I do to GroupBy NameID, but view the Name instead, being
that I can only have one Row and one Column per crosstab query?

Thanks.

 

[Duane Hookom]

Group by both NameID and Name as row headings.

BTW: Name is not a good name for a field since every field has a name
property which can cause confusion. You are much better off using field
names like EmpFirstName, EmpLastName, CustFirstName, ContactFirst,...

 

[Tim 9000]

Perfect. For some reason I thought you could only use one row and column
value per crosstab query.

Thanks.

 

[Duane Hookom]

You can use as many row headings as you like. Generally you can use only one
value and one column heading but there are methods around this also.