If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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!! |
#2
|
|||
|
|||
Is there any way to get the report to look like this?
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!! |
#3
|
|||
|
|||
Is there any way to get the report to look like this?
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!! |
Thread Tools | |
Display Modes | |
|
|