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

Changing access record to horizontal output

P: n/a
I have a problem regarding the output of data from a access xp
database. Basically we have data in the following format in a table:

person1 result1 result2
person1 result1 result2
person1 result1 result2
person2 result1 result2
person2 result1 result2
Basically I want this data output in the following format in excel.

person1 result1 result2 result1 result2 result1 result2
person2 result1 result2 result1 result2
Can anyone give me any help on this please, im a bit stuck.

Thanks in advance
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Create a crosstab query

"Colin Graham" <cs********@hotmail.com> wrote in message
news:ee**************************@posting.google.c om...
I have a problem regarding the output of data from a access xp
database. Basically we have data in the following format in a table:

person1 result1 result2
person1 result1 result2
person1 result1 result2
person2 result1 result2
person2 result1 result2
Basically I want this data output in the following format in excel.

person1 result1 result2 result1 result2 result1 result2
person2 result1 result2 result1 result2
Can anyone give me any help on this please, im a bit stuck.

Thanks in advance

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.