• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 403
  • Last Modified:

display the data in tbl1 differently- like tbl2

hello -
attached sample db-
I have tables like tbl1-

need to display data like in tbl2-
Is there a way to query tbl1 to do this?
thank you
Test-103.accdb
0
davetough
Asked:
davetough
1 Solution
 
als315Commented:
You can use Crosstab query, but there is one problem: column names will be ordered alphabetically. You should add numbers before column name. Look at sample
Test-103.accdb
0
 
davetoughAuthor Commented:
great thanks-
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: CompTIA Cloud+

The CompTIA Cloud+ Basic training course will teach you about cloud concepts and models, data storage, networking, and network infrastructure.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now