Help with Horizontal report format

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



"Fons Ponsioen" wrote in message
...
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
-----Original Message-----
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





.

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



"Fons Ponsioen" wrote in message
...
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
-----Original Message-----
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

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
-----Original Message-----
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



"Fons Ponsioen"
wrote in message
...
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
-----Original Message-----
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





.



.

I place a response to the earlier thread, but here it goes
again.
What I would do is create a report grouped by Customer.
Next, create a subreport with multiple columns set for
accross and down. You may be able to make it several
columns as needed.
Place this subreport in the main report in the group
footer linked to the Customer, I think this will
accomplish what you have outlined.
Fons
-----Original Message-----
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



"Fons Ponsioen"
wrote in message
...
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
-----Original Message-----
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


.

Enzo Diana wrote:

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?


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/Otherdownload.asp?SampleName='Generic%20Function%2 0To%20Concatenate%20Child%20Records'

--
Marsh
MVP [MS Access]

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

"Marshall Barton" wrote in message
...
Enzo Diana wrote:

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?


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/Otherdownload.asp?SampleName='Generic%20Function%2 0To%20Concatenate%20Child%20Records'

--
Marsh
MVP [MS Access]