Reports - Showing a field in landscape instead of portrait

I have a field called "Questions" that prints four separate values ( I know this field should not be set up like this I didn't create the database). When I run my report the values in this field show up on my report like this, one on top of the other:

Admit Doctor
ER Doctor
Unit
Admit R/N

I would like these values to show on my report like this, one after the other left to right with 5 spaces inbetween each value (this message will not let me show the spaces in between, don't want them running together like it shows when I preview this message):

Admit Doctor ER Doctor Unit Admit R/N

Is there anyway of doing this?

So is the Questions field part of the report Detail Section and the 4 values are 4 records (detail x 4)?

Or is that the Questions field has carriage returns so a single Questions field has the 4 values?

You posted this question a few weeks ago and we responded to it. Did you try any of the solutions or do you have new information to share?

Thread is here:

<< CLICK HERE >>

No, the solutions did not help. When the nurses enter this information into the tool, each field has it's own data entry field but when the database is downloaded for my use all those fields are put into one field "Questions". It's not as simple as asking them to separate the fields because the database is formatted this way for many different companies. There are no comma's for me to use as a lever to split the fields back into individual fields so I was thinking that instead of these fields showing on my report one under the other I was hoping for a way for them to show on my report one "after" the other so it saves space on my report. It's just a mess because it messes up my counting of the fields inside this "Question" field also. Providing an Access database download is a rather new thing for this company and I'm hoping that this will be corrected in the future.

This is from the last thread (posted by me). It is almost impossible to help you if you don't show us what the data looks like there are just too many variables, where spaces are located, are there commas, do the commas mean different things, etc. Post an example of your data and post any rules that the data follows (if you're aware of any).

Remember encapsulate your sample strings in [ code ] [ /code ] markers (remove the spaces between the brackets and the code /code text)

Well based on what you've posted there is a seperator. It is a carriage return and or a line feed.

You'll have to figure out if it's just a carriage return (Chr(13)) a line feed (chr(10)) or a carriage return/line feed (chr(13) & chr(10)). But once you've determined that, the solution is easy.

SELECT <field1>,..., Replace([Questions], Chr(13) & chr(10), space(5)), ...
FROM <table>
...