Creating a list within a report

[mshull]

I am creating a report that contains both text and lists to be embedded within the text. I would like the output to look similar to this:

------------------------------------------

The following is able to work this weekend:

John

Mary

Sam

Joey - maybe

------------------------------------------

In my database I have the following radio boxes-

Bobby yes no maybe

john yes no maybe

jim yes no maybe

Mary yes no maybe

Sam yes no maybe

Joey yes no maybe

Lisa yes no maybe

I would like if the radio box = yes for it to show the field name (i.e Bobby, John...) = no not to show anything and =maybe to show the field name & maybe

I would appreciate any help here. This is a huge deal to finish a database for my wife. I need to get this off of her to-do list .

Thank you!

[IdealData]

Make a calculation field that evaluates the content you want based on the criteria you suggest, and print the calculated field.

Where:

working is a field for Yes/No/Maybe

person is a name

Case(

working = "Yes" ; person ;

working = "Maybe" ; person & " - maybe" ;

""

)

[mshull]

I figured out my mistake. Thank you!

Edited May 30, 2009 by Guest

[comment]

(You have deleted the post I was trying to reply to, so this may seem out of context.)

You should use records instead of fields. I am not sure what the real situation is, but in the example you gave, there would be a table of People and a related table of Availabilities. A record in Availabilities would hold the person's ID, the date (or period) of interest, and the person's availability status. Then you could easily produce a report sorted by date and by availability.

[mshull]

Sorry for the deletion. The way I set up the database, they are fields unfortunately.

The database is actually a scoring table for various tests. Each kid goes through 100's of tests to test for functional eligibility. The tests are individual fields that there is a pass, fail, or N/A field. Based on the score (pass, fail, or N/A) entered for that child, I need to print a report showing the individual tests passed or N/A (I don't show Failed tests).

I think I have it worked out, and I am using Case for each test with + between them for additional tests.

What I am still trying to figure out, and I am sure its obvious is how to "return" between each of the tests.

Thanks again in advance. This has been one hell of a learning experience. :P