If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Combining Records from the Same Table?
Pardon me if this has been posted previously, or if this is in the wrong forum.
I have one table with records that are somewhat repetitive, however one field within the record varies. I would like to "clean up" the table. Here is a simplified example of what I am working with: ID Name Number Question Response 123 John Smith 123 Age 32 123 John Smith 123 Gender Male I would like the table to be: ID Name Number Age Gender 123 John Smith 123 32 Male It seems like something that should be so very easy, but I'm a bit rusty on Access and the answer is not coming to me, outside of exporting the data to Excel and doing things manually. Thank you ahead of time for your assistance. |
#2
|
|||
|
|||
Combining Records from the Same Table?
Check out crosstab queries in Help. It could be just what you need.
-- Jerry Whittle, Microsoft Access MVP Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder. "Brad Autry" wrote: Pardon me if this has been posted previously, or if this is in the wrong forum. I have one table with records that are somewhat repetitive, however one field within the record varies. I would like to "clean up" the table. Here is a simplified example of what I am working with: ID Name Number Question Response 123 John Smith 123 Age 32 123 John Smith 123 Gender Male I would like the table to be: ID Name Number Age Gender 123 John Smith 123 32 Male It seems like something that should be so very easy, but I'm a bit rusty on Access and the answer is not coming to me, outside of exporting the data to Excel and doing things manually. Thank you ahead of time for your assistance. |
Thread Tools | |
Display Modes | |
|
|