Data in rows to colums

  • Thread starter Thread starter Brennan
  • Start date Start date
B

Brennan

Hello all,

I am a bit new to queries so any help here would be appreciated. Have a
table with the following col data:

Name Month Results

I would like to build a query that compared the same name across several
months that I put in criteria box of the query. For example:

Name Jan Results Feb Results Mar Results

How can I structure a query to take this data in cols and rearrange it to
rows? Thanks for the help.

Brennan
 
Hello all,

I am a bit new to queries so any help here would be appreciated. Have a
table with the following col data:

Name Month Results

I would like to build a query that compared the same name across several
months that I put in criteria box of the query. For example:

Name Jan Results Feb Results Mar Results

How can I structure a query to take this data in cols and rearrange it to
rows? Thanks for the help.

Brennan
Click to expand...

It sounds like you want to do the opposite - take multiple rows (each with a
different month) and arrange it into columns... right?

If so, the tool of choice is a Crosstab Query. Create a new Query and use the
Crosstab query wizard (for starters, this may need some tweaking depending on
your actual table structure). Note that Name and Month are both reserved words
and bad choices of fieldname, and that a month name by itself is ambiguous (Do
you want December to mean December 2008 or 2007?)


John W. Vinson [MVP]
 
If what you want is - Name Jan Results Feb Results Mar Results
then a crosstab query would do it.
 
Back
Top