how do i put records on a report across the page?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello
I am creating a label report for feed mixtures and I would like to put the
record "material" across the page. I have seen the way to do it in columns
but I want the records to follow on with "," between them. eg "rolled barley,
rolled oats, molasses". Please could someone point me in the right direction.
Cheers
 
Duane

Thanks for that I copied the basConcatenate module and re-created the query
but I can't get any commas for the life of me. What am I missing?

Table Production Sheet contains records Mix No, Material, KG Per Batch
Table Mixtures contains records Mix No, Mix Name

my query reads
Materials: Concatenate("SELECT Material FROM [Production Sheet] WHERE [Mix
No] =" & [Mix No] & " ORDER BY [KG Per Batch]")

??
 
Its ok I've done it now.
Instead of cut and pasting the module I imported it and re ran the query
commas a plenty!
Thanks again.
 
Back
Top