Help with Horizontal report format

  • Thread starter Thread starter Enzo Diana
  • Start date Start date
E

Enzo Diana

For each "Customer" in my Access 2000 database there is a corresponding
(and varying) set of numbers. The problem I have is that my query based
report lists these numbers down the page. I need these to go across the
page. Is there a way to do this?
Thanks in anticipation
 
You did not provide much detail, but one poosible solution
is to have a cross-tab query.
the second possibility create a subreport with columns. A
lot will depend on exactly what you are starting with and
what you are trying to accomplish.
Hope this helps.
Fons
 
Fons thanks for your response.
As an example lets say there are only two fields "Customer" and "Product
ID". Normally a report will have the following layout - with the Customer on
top and the Product ID listed vertically, with a new line for each (product
ID).

"Customer a"
11
32
44
53
57
etc

"Customer b"
23
44
54
66
68
etc

However this needs to be in the following format

"Customer a" 11 32 44 53 57 etc
"Customer b" 23 44 54 66 68 etc
 
Hi. I think the way I would approach this is to create a
report grouped by Customer.
Than create a subreport with maybe 6 or seven columns and
make sure this is set up for across and than down, you may
adjust the number of columns within reason. Than you can
place the subreport adjacent to the customer textbox in
the group footer.
Hope this helps.
Fons
 
Enzo said:
For each "Customer" in my Access 2000 database there is a corresponding
(and varying) set of numbers. The problem I have is that my query based
report lists these numbers down the page. I need these to go across the
page. Is there a way to do this?
Click to expand...


A different way to approach this kind of thing is to use a
group by query, but then use a function to concatenate the
values into a list. The function could be used in the query
or in a text box in the report. There's several examples of
this kind of function out there on the web, here's Duane's
version:

http://www.rogersaccesslibrary.com/...Generic Function To Concatenate Child Records'
 
Gratitude to those who responded.
As a resullt of the suggestions posted the problem has resolved.
Thanks again I can now stop pulling my hair out
 
Back
Top