Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Need to change the style of a report

Status
Not open for further replies.
aageorge

aageorge

Technical User
Jun 28, 2003
51
US
Hi,

I have a couple of tables with these fields:

Date(Date/Time)
Part 1(Number)
Part 2(Number)
Part 3(Number) etc.

I need to setup the report so that it prints out in this format:

7/10 7/11 7/12 7/13
Part 1 4 5 1 4
Part 2 3 2 5 3
Part 3 5 6 10 4
Part 9 2 3 2 1

The normal report wizard puts it in a topdown format which I don't want. I tried crosstab queries but I had no luck with that. I have about 10 tables that I need to put in the above format. Any suggestions will be appreciated.....
 
Status
Not open for further replies.

Similar threads

breezett93
  • Locked
  • Question
Report often takes multiple minutes to load, lots of formatting time between pages
Replies
5
Views
570
dhookom
dhookom
TrekBiker
  • Locked
  • Question
Print multiple copies of report data 1
Replies
5
Views
556
dhookom
dhookom
SamuelR
  • Locked
  • Question
Dlookup in a report
Replies
13
Views
706
dhookom
dhookom
Zandy12
  • Locked
  • Question
Repeat the Report Header after Page Header / Details ends.
Replies
1
Views
867
dhookom
dhookom
renigar
  • Locked
  • Question
Access 365 Report use nickname if exist instead of 1st name
Replies
4
Views
3K
renigar
renigar

Part and Inventory Search

Sponsor

Back
Top