October 6, 200421 yr I have a database in which I have a list of "Area of Expertise" beside each Area I have a checkbox formatted to display only one checkbox. The user checks the box to indicate that they have experience in that area. There are 34 checkboxes on my layout. Now I want to do a "Summary Report" which will only display the area of expertise that are CHECKED. How do I do this? Do I have to use a calaculation field? Instead of bloating my orginal file with a whole bunch of calaculation fields can I use a different table? Thanks in advance.
October 6, 200421 yr If you only want to display a list of which options have been selected, you can create a value list based on the field. Then create an unstored calculation of ValueListItems( Get(FileName); "yourvaluelist" ) and display this on your layout. If you want a comma-delimited list, use Substitute( ValueListItems( Get(FileName); "yourvaluelist" ); "
Create an account or sign in to comment