Is there any way to get the report to look like this?

I have a query that gives me the following fields across the top:

Work Center, Work Center Descr, IDH, IDH Descr , Date , Qty , Shift

Is there any way to get a report that would orient the data this way:

Work Center Shift Production Details 4-May 5-May 6-May
FM 15 4-up 1 IDH 827634 827645 827634
IDH Descr F38 SF450 F38
Qty 14400 18000 10000
FM 15 4-up 2 IDH 827634
IDH Descr Formula 38
Qty 13000

And so forth? I want there to be a "box" for each date - workcenter - shift
combo that houses the IDH, IDH Descr, and qty needed to produce. Is that
possible?

I tried crosstabs, but I have way too many variables!

I would be happy to attach things, if it will help illustrate better.

Thanks!!

I would try create a report with multiple copies of a subreport that displays
the multiple fields. You would need to have the main report based on a totals
query with a beginning date for the first date column. Then use the DateAdd()
function in several other text boxes that can be used in the Link Master
properties. Set up other fields as more values for link master/child.

--
Duane Hookom
Microsoft Access MVP


"GoBrowns!" wrote:

I have a query that gives me the following fields across the top:

Work Center, Work Center Descr, IDH, IDH Descr , Date , Qty , Shift

Is there any way to get a report that would orient the data this way:

Work Center Shift Production Details 4-May 5-May 6-May
FM 15 4-up 1 IDH 827634 827645 827634
IDH Descr F38 SF450 F38
Qty 14400 18000 10000
FM 15 4-up 2 IDH 827634
IDH Descr Formula 38
Qty 13000

And so forth? I want there to be a "box" for each date - workcenter - shift
combo that houses the IDH, IDH Descr, and qty needed to produce. Is that
possible?

I tried crosstabs, but I have way too many variables!

I would be happy to attach things, if it will help illustrate better.

Thanks!!

Actually, you might want to check the calendar reports demo at
http://www.access.hookom.net/Samples.htm. The basic calendar report shows how
this might work.

--
Duane Hookom
Microsoft Access MVP


"GoBrowns!" wrote:

I have a query that gives me the following fields across the top:

Work Center, Work Center Descr, IDH, IDH Descr , Date , Qty , Shift

Is there any way to get a report that would orient the data this way:

Work Center Shift Production Details 4-May 5-May 6-May
FM 15 4-up 1 IDH 827634 827645 827634
IDH Descr F38 SF450 F38
Qty 14400 18000 10000
FM 15 4-up 2 IDH 827634
IDH Descr Formula 38
Qty 13000

And so forth? I want there to be a "box" for each date - workcenter - shift
combo that houses the IDH, IDH Descr, and qty needed to produce. Is that
possible?

I tried crosstabs, but I have way too many variables!

I would be happy to attach things, if it will help illustrate better.

Thanks!!