Report results printing and viewing

[Slow Learner]

I have a report that has a link to a table with a field called results. When the results field appears on screen (or prints out) it reports the contents of the field vertically on the page. I would like the results to show horizontally across the page in one line.
Is there a special code that I can put in to make this happen? and if so where in the hierarchy of the coding would I place this?
Thanks

 

[Slow Learner]

Still asking for input

Please take a moment to shed some light on this subject, or at least point me in the right direction where to find the information on this subject. Thanks everyone!

 

[pbaldy]

Is the Vertical property of the textbox set to Yes?

 

[Slow Learner]

checking what you ask

Do not know will check and report back.

 

[Slow Learner]

Set to no on vertical

The property in the report text box is set "no" to vertical. When I change this to "yes" it does not do the job. It still puts the field entries each on a seperate line but just changes the direction so you can not read them.

 

[pbaldy]

Maybe I'm not visualizing what you've got properly. Can you either post a sample db or at least a picture of it?

 

[Slow Learner]

Picture?

How would I post a picture? That sounds like a great idea to get my point across.
But basically it looks like this

Field
Field entry1
Field entry 2
Fiedl entry 3

I want the report to look like this:

Field
Field entry 1 Field entry 2 Field entry 3

Does that help??

 

[pbaldy]

Ah, I was visualizing the wrong thing. When you said "contents of a field", I thought you meant text was literally vertical instead of horizontal. The most common way of doing what you want is a crosstab query/report. Take a look at the crosstab query wizard and see if it will do what you want.

BTW, You can post a picture simply by attaching a JPG file to your post.

 

[Slow Learner]

Never done a cross tab anything

this will be a new experience

 

[Slow Learner]

Cross tab query

Well the query went well and the report does show the fields left to right, however a cross tab query (which I used first) seems to be for numeric field values and my values in the field are not numeric. The end result is my report shows my field values as column headers and then the row values are my participant numbers, so far so good.
Now the question
Beside each participant (column 1) there is a 0 in the column of the value used. Can I change the 0 to say an X or maybe a yes or no? If so how would I do this?

 

[pbaldy]

What does the SQL look like now? Sometimes when I just want an X or something to indicate matching records or whatever, I'll replace a count function (or whatever) with something like this:

TRANSFORM IIf(Count(TableName.FieldName)>0,"X","") AS NewField
...

 

[Slow Learner]

That works

Can you translate the SQL to me. I am not that familiar with it but I was able to get it to work in my DB. The one thing I noticed is that when you run the query it puts a row at the start that is all X's for all fields across, save and except the first column.
How can I omit this row?

 

[pbaldy]

It would be easier to deal with your actual SQL. If you can post that or even better a sample db, it would help.

 

[Slow Learner]

not that complicated

I thought you could possibly translate into more understandable language the Transform.... statement so that I could see a little more clearly what it is that I have done that works.