CrossTab Query that shows original data (text)

  • Thread starter Thread starter greene2j
  • Start date Start date
G

greene2j

I am a scheduler and would like to build a pivot table in Excel or a Cross
Tab Query in Access that shows the data in its original form (text) instead
of calculating the count, sum, avg., etc.

Row headings would have member’s names. Column headings would have times.
Data items would be the name of the assignment.

Any suggestions would be appreciated.

Thanks.

Jim G
 
You can use a text field for the Value of a crosstab with FIRST or LAST or
MIN or MAX.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help with crosstab query 10
crosstab query column heading 2
Problems with Crosstab Query 4
update crosstab 1
Crosstab column data count 6
crosstab - multiple values required 3
Crosstab Column Headings 1
Crosstab or pivot table 1

Back
Top