Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Changing columns into rows and rows into columns
0 views
Skip to first unread message
bhowk
Jun 5, 2007, 5:15:03 PM6/5/07
to
How do I change columns into rows and rows into columns in Access Datasheet
View?
View?
John W. Vinson
Jun 5, 2007, 7:41:44 PM6/5/07
to
On Tue, 5 Jun 2007 14:15:03 -0700, bhowk <bh...@discussions.microsoft.com>
wrote:
wrote:
>How do I change columns into rows and rows into columns in Access Datasheet
>View?
Generally, in a properly normalized database, you don't!
You can use a "Crosstab Query" to spread record values across the page in
columns; or a "Normalizing Union Query" to take a wide-flat table and turn it
into a tall-thin one; or a "Pivot Table Query" using Excel to analyze data.
Could you describe what data you're working with and what you want to
accomplish with it?
John W. Vinson [MVP]
0 new messages