Make text box horizontal

[Starbuckz8]

Hey guys, I've got a kinda hard question i've yet to figure out. Everyday our purchasing department runs a report thats about 600 pages long and I've only got one signle task remaining. If you look at the picture below from microsoft's website it would help me explain easier.

Where i says
Product name and then
Chang
Chai
Ainseed syrub etc

going down

I need it going across, so it reads like this:

Product name:
Chang Chai Ainseed syrub


This is for days of the week of items to order, items ordered and awaiting delivery, items delivered and so on...

If anyone could be of help it would be a massive help

Thanks.

http://img.microsoft.com/library/me...rodtechnol/office/office2000/tips/accss01.gif

 

[Crowley16]

have a look at crosstab/pivot charts or queries...

--------------------
Procrastinate Now!

 

[dhookom]

You should be able to use a multi-column report. If that doesn't seem to work, the multi-column report can be a subreport on a main report. There is also a sample generic concatenate function at faq701-4233.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]