Crosstab query with dupl values in row question

  • Thread starter Thread starter Tim 9000
  • Start date Start date
T

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.
 
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,...
 
Perfect. For some reason I thought you could only use one row and column
value per crosstab query.

Thanks.
 
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.
 
Back
Top