combining fields

  • Thread starter Thread starter blindman
  • Start date Start date
B

blindman

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!
 
Make a subreport for 'conveyor name' and place in the 'conveyor type' heading
using the Master/Child links of the 'conveyor name' field.
 
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?
 
Use a totals query for the subreport with just ''conveyor type' and 'conveyor
name'.
 
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!
 
SELECT [conveyor type], [conveyor name]
FROM YourTable
GROUP BY [conveyor type], [conveyor name];
 
Thankyou, problem solved. Champion!
--
blindman


KARL DEWEY said:
SELECT [conveyor type], [conveyor name]
FROM YourTable
GROUP BY [conveyor type], [conveyor name];

--
Build a little, test a little.


blindman said:
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!
Click to expand...
Click to expand...
 
blindman said:
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.
Click to expand...


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/forum/forum_posts.asp?TID=16&SID=66a1ez5f2b53453dc951c912736eca71
 
Back
Top