|
| 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
December 8th, 2009, 09:09 PM
posted to microsoft.public.access.queries
|
|||
|
|||
combining fields
I have a report that groups three fields together, 'conveyor type', 'conveyor
name' and 'maint. records'. There are multiple 'conveyor names' and 'maint. records'for each 'conveyor type'. I have managed to group everything together that is repetitive (a lot of the 'maint. records are the same). So i have a report that has a 'conveyor type' heading with all the 'maint records' underneath very nicely. However I wish to list the 'conveyor names' side by side next to the 'conveyor type'heading. I can only get one 'conveyor name ' to list. I have tried to run a query to place conveyor names into the one field so I could put them on the report as a subreport. Not having any luck. If any one can help that would be great. Hope I am not being too confusing. Cheers! -- blindman 
|
|
#2
December 8th, 2009, 10:27 PM
posted to microsoft.public.access.queries
|
|||
|
|||
|
combining fields
Make a subreport for 'conveyor name' and place in the 'conveyor type' heading
using the Master/Child links of the 'conveyor name' field. -- Build a little, test a little. "blindman" wrote: I have a report that groups three fields together, 'conveyor type', 'conveyor name' and 'maint. records'. There are multiple 'conveyor names' and 'maint. records'for each 'conveyor type'. I have managed to group everything together that is repetitive (a lot of the 'maint. records are the same). So i have a report that has a 'conveyor type' heading with all the 'maint records' underneath very nicely. However I wish to list the 'conveyor names' side by side next to the 'conveyor type'heading. I can only get one 'conveyor name ' to list. I have tried to run a query to place conveyor names into the one field so I could put them on the report as a subreport. Not having any luck. If any one can help that would be great. Hope I am not being too confusing. Cheers! -- blindman
|
|
#3
December 8th, 2009, 10:56 PM
posted to microsoft.public.access.queries
|
|||
|
|||
|
combining fields
Thanks Karl
I tried this and I do get all the 'conveyor names to display. However, they run down the page and i have multiple instances of the same 'conveyor name'. I would like single instances and the 'conveyor names' to be listed side by side. I also tried making a new report where I could 'hide duplicates' and placing this on my main report but similiar thing happens, only where the multiple instances would have appeared I get space running down the page. I know this method you have suggested is very close to what I want, is there any way of fine tuning to ignore multiples and to place the 'conveyor names' side by side? -- blindman "KARL DEWEY" wrote: Make a subreport for 'conveyor name' and place in the 'conveyor type' heading using the Master/Child links of the 'conveyor name' field. -- Build a little, test a little. "blindman" wrote: I have a report that groups three fields together, 'conveyor type', 'conveyor name' and 'maint. records'. There are multiple 'conveyor names' and 'maint. records'for each 'conveyor type'. I have managed to group everything together that is repetitive (a lot of the 'maint. records are the same). So i have a report that has a 'conveyor type' heading with all the 'maint records' underneath very nicely. However I wish to list the 'conveyor names' side by side next to the 'conveyor type'heading. I can only get one 'conveyor name ' to list. I have tried to run a query to place conveyor names into the one field so I could put them on the report as a subreport. Not having any luck. If any one can help that would be great. Hope I am not being too confusing. Cheers! -- blindman
|
|
#4
December 8th, 2009, 11:24 PM
posted to microsoft.public.access.queries
|
|||
|
|||
|
combining fields
Use a totals query for the subreport with just ''conveyor type' and 'conveyor
name'. -- Build a little, test a little. "blindman" wrote: Thanks Karl I tried this and I do get all the 'conveyor names to display. However, they run down the page and i have multiple instances of the same 'conveyor name'. I would like single instances and the 'conveyor names' to be listed side by side. I also tried making a new report where I could 'hide duplicates' and placing this on my main report but similiar thing happens, only where the multiple instances would have appeared I get space running down the page. I know this method you have suggested is very close to what I want, is there any way of fine tuning to ignore multiples and to place the 'conveyor names' side by side? -- blindman "KARL DEWEY" wrote: Make a subreport for 'conveyor name' and place in the 'conveyor type' heading using the Master/Child links of the 'conveyor name' field. -- Build a little, test a little. "blindman" wrote: I have a report that groups three fields together, 'conveyor type', 'conveyor name' and 'maint. records'. There are multiple 'conveyor names' and 'maint. records'for each 'conveyor type'. I have managed to group everything together that is repetitive (a lot of the 'maint. records are the same). So i have a report that has a 'conveyor type' heading with all the 'maint records' underneath very nicely. However I wish to list the 'conveyor names' side by side next to the 'conveyor type'heading. I can only get one 'conveyor name ' to list. I have tried to run a query to place conveyor names into the one field so I could put them on the report as a subreport. Not having any luck. If any one can help that would be great. Hope I am not being too confusing. Cheers! -- blindman
|
|
#5
December 8th, 2009, 11:49 PM
posted to microsoft.public.access.queries
|
|||
|
|||
|
combining fields
I have tried making a 'totals query'. Really don't know what this is, i have
made a query that can sum or count, but unsure what you mean by totals and how this will help me. Sorry! -- blindman "KARL DEWEY" wrote: Use a totals query for the subreport with just ''conveyor type' and 'conveyor name'. -- Build a little, test a little. "blindman" wrote: Thanks Karl I tried this and I do get all the 'conveyor names to display. However, they run down the page and i have multiple instances of the same 'conveyor name'. I would like single instances and the 'conveyor names' to be listed side by side. I also tried making a new report where I could 'hide duplicates' and placing this on my main report but similiar thing happens, only where the multiple instances would have appeared I get space running down the page. I know this method you have suggested is very close to what I want, is there any way of fine tuning to ignore multiples and to place the 'conveyor names' side by side? -- blindman "KARL DEWEY" wrote: Make a subreport for 'conveyor name' and place in the 'conveyor type' heading using the Master/Child links of the 'conveyor name' field. -- Build a little, test a little. "blindman" wrote: I have a report that groups three fields together, 'conveyor type', 'conveyor name' and 'maint. records'. There are multiple 'conveyor names' and 'maint. records'for each 'conveyor type'. I have managed to group everything together that is repetitive (a lot of the 'maint. records are the same). So i have a report that has a 'conveyor type' heading with all the 'maint records' underneath very nicely. However I wish to list the 'conveyor names' side by side next to the 'conveyor type'heading. I can only get one 'conveyor name ' to list. I have tried to run a query to place conveyor names into the one field so I could put them on the report as a subreport. Not having any luck. If any one can help that would be great. Hope I am not being too confusing. Cheers! -- blindman
|
|
#6
December 9th, 2009, 12:06 AM
posted to microsoft.public.access.queries
|
|||
|
|||
|
combining fields
SELECT [conveyor type], [conveyor name]
FROM YourTable GROUP BY [conveyor type], [conveyor name]; -- Build a little, test a little. "blindman" wrote: I have tried making a 'totals query'. Really don't know what this is, i have made a query that can sum or count, but unsure what you mean by totals and how this will help me. Sorry! -- blindman "KARL DEWEY" wrote: Use a totals query for the subreport with just ''conveyor type' and 'conveyor name'. -- Build a little, test a little. "blindman" wrote: Thanks Karl I tried this and I do get all the 'conveyor names to display. However, they run down the page and i have multiple instances of the same 'conveyor name'. I would like single instances and the 'conveyor names' to be listed side by side. I also tried making a new report where I could 'hide duplicates' and placing this on my main report but similiar thing happens, only where the multiple instances would have appeared I get space running down the page. I know this method you have suggested is very close to what I want, is there any way of fine tuning to ignore multiples and to place the 'conveyor names' side by side? -- blindman "KARL DEWEY" wrote: Make a subreport for 'conveyor name' and place in the 'conveyor type' heading using the Master/Child links of the 'conveyor name' field. -- Build a little, test a little. "blindman" wrote: I have a report that groups three fields together, 'conveyor type', 'conveyor name' and 'maint. records'. There are multiple 'conveyor names' and 'maint. records'for each 'conveyor type'. I have managed to group everything together that is repetitive (a lot of the 'maint. records are the same). So i have a report that has a 'conveyor type' heading with all the 'maint records' underneath very nicely. However I wish to list the 'conveyor names' side by side next to the 'conveyor type'heading. I can only get one 'conveyor name ' to list. I have tried to run a query to place conveyor names into the one field so I could put them on the report as a subreport. Not having any luck. If any one can help that would be great. Hope I am not being too confusing. Cheers! -- blindman
|
|
#7
December 9th, 2009, 03:09 AM
posted to microsoft.public.access.queries
|
|||
|
|||
|
combining fields
Thankyou, problem solved. Champion!
-- blindman "KARL DEWEY" wrote: SELECT [conveyor type], [conveyor name] FROM YourTable GROUP BY [conveyor type], [conveyor name]; -- Build a little, test a little. "blindman" wrote: I have tried making a 'totals query'. Really don't know what this is, i have made a query that can sum or count, but unsure what you mean by totals and how this will help me. Sorry! -- blindman "KARL DEWEY" wrote: Use a totals query for the subreport with just ''conveyor type' and 'conveyor name'. -- Build a little, test a little. "blindman" wrote: Thanks Karl I tried this and I do get all the 'conveyor names to display. However, they run down the page and i have multiple instances of the same 'conveyor name'. I would like single instances and the 'conveyor names' to be listed side by side. I also tried making a new report where I could 'hide duplicates' and placing this on my main report but similiar thing happens, only where the multiple instances would have appeared I get space running down the page. I know this method you have suggested is very close to what I want, is there any way of fine tuning to ignore multiples and to place the 'conveyor names' side by side? -- blindman "KARL DEWEY" wrote: Make a subreport for 'conveyor name' and place in the 'conveyor type' heading using the Master/Child links of the 'conveyor name' field. -- Build a little, test a little. "blindman" wrote: I have a report that groups three fields together, 'conveyor type', 'conveyor name' and 'maint. records'. There are multiple 'conveyor names' and 'maint. records'for each 'conveyor type'. I have managed to group everything together that is repetitive (a lot of the 'maint. records are the same). So i have a report that has a 'conveyor type' heading with all the 'maint records' underneath very nicely. However I wish to list the 'conveyor names' side by side next to the 'conveyor type'heading. I can only get one 'conveyor name ' to list. I have tried to run a query to place conveyor names into the one field so I could put them on the report as a subreport. Not having any luck. If any one can help that would be great. Hope I am not being too confusing. Cheers! -- blindman
|
|
#8
December 9th, 2009, 03:28 AM
posted to microsoft.public.access.queries
|
|||
|
|||
|
combining fields
blindman wrote:
I have a report that groups three fields together, 'conveyor type', 'conveyor name' and 'maint. records'. There are multiple 'conveyor names' and 'maint. records'for each 'conveyor type'. I have managed to group everything together that is repetitive (a lot of the 'maint. records are the same). So i have a report that has a 'conveyor type' heading with all the 'maint records' underneath very nicely. However I wish to list the 'conveyor names' side by side next to the 'conveyor type'heading. I can only get one 'conveyor name ' to list. A different way would be to create a function to get all the names in a comma delimited string. There are quite a few of these function on the web, but I like the one at: http://www.rogersaccesslibrary.com/f...c91 2736eca71 -- Marsh MVP [MS Access]
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
