By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,493 Members | 1,351 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,493 IT Pros & Developers. It's quick & easy.

Transpose Rows to Column Headings

P: 3
I want to make the rows become column headings in an Access table or query. The data changes based on input to a form. It looks like this:

A B
N1 1
N2 2
N3 3
N4 4

Where A and B are the column headings.

I want it to create a table/query that looks like this:

A N1 N2 N3 N4
B 1 2 3 4

Where rows N1...N4 become the column headings.

I am not proficient at SQL commands so please be specific on what I need to do.

Thank you.
Jul 20 '07 #1
Share this Question
Share on Google+
5 Replies


Rabbit
Expert Mod 10K+
P: 12,315
From the menus:
Query > Crosstab Query
Jul 20 '07 #2

P: 3
From the menus:
Query > Crosstab Query
It says that I do not have enough fields to perform a Crosstab Query.
Jul 20 '07 #3

Rabbit
Expert Mod 10K+
P: 12,315
For a crosstab you need a field that will be the columns, a field that will be the row, and a field that will be the values.
Jul 20 '07 #4

P: 3
For a crosstab you need a field that will be the columns, a field that will be the row, and a field that will be the values.
I only have 2 Fields. Is there any way to transpose in Access?
Jul 20 '07 #5

Rabbit
Expert Mod 10K+
P: 12,315
I only have 2 Fields. Is there any way to transpose in Access?
Create a psuedo row field.
Jul 20 '07 #6

Post your reply

Sign in to post your reply or Sign up for a free account.