How to change vertical fields to horizontal

[adeng]

I am using MSAccess 2003 to develop a program which is used to monitor staff performace, but I got problem when I creating the report because of the format of the Query.

I have a query shows in a vertical way like this:
[personID]----[fullName]----[totalWorkingHou rs]
1-------------------bill-------------------40
2-------------------kate-----------------38

However, is that possible to make the query to horizontal like this
[personID]]----[fullName]----[totalWorkingHou rs]----[personID]----[fullName]----[totalWorkingHou rs]
1-------------------bill-------------------40-------------------2-------------------kate-----------------38

can someone help me with this please,thanks

[nico5038]

When you have the report in design mode, select File/Page Setup.
This will allow the selection of multiple columns in "N" or "Z" direction.

Nic;o)

[adeng]

I GOT IT!It works,I never thought this problem can be solved so easily,many thanks to nico5038

[nico5038]

I always like these solutions best <LOL>

Success with your application !

Nic;o)