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!

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

Display Data down then across in a report

Status
Not open for further replies.

gxd135

MIS
Jun 18, 2001
41
US
I have a table with the following data.

load store door# qty
15 104 100 5000
15 152 56 5000
19 120 23 6000
19 150 55 8000
21 156 23 9000

What I want the report to show is the following:

Load 15 Load 19
store qty store qty
104 5000 120 6000
152 5000 150 8000

It is a little more complicated than that, but that is the jist of it. I want all stores with each corresponding quantity underneath each load. It needs to print 5 across then down. I know how to print across then down in the column settings, but I can't get the format to look like this. Any suggestions are greatly appreciated.

THANKS

Greg
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top