May 30, 200916 yr Newbies 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!
May 30, 200916 yr 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" ; "" )
May 30, 200916 yr Author Newbies I figured out my mistake. Thank you! Edited May 30, 200916 yr by Guest
May 30, 200916 yr (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.
May 30, 200916 yr Author Newbies 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
Create an account or sign in to comment