Parsing out check-boxed entries into a report

[JD2775]

Hi,

For sake of simplicity I have warehouses that I want to record whether they have maintenance checks done on them or not. I have the warehouses in a check-box layout, and I check each warehouse that has been screened. This goes into the database with a date associated with them. In a related table is the sqft for each of the warehouses. What I want is a report that basically looks like a table view where you enter a date and the table populates with all the warehouses in one column, and the related square feet of each house would populate the second column.

The problem I am having is since this is a checkbox field, I am ending up with one row of data with ALL the warehouses in one cell, and the TOTAL sq feet in the other column. I need to break them out individually in the table view report.

Is there formula to parse out the checked warehouses into individual rows of data?

Thanks

[comment]

I have the warehouses in a check-box layout, and I check each warehouse that has been screened.

This may not be the best method to structure your data. Still, you should be able to place a portal to the Warehouses table on this layout - so that each row will show the individual warehouse's square footage.

[JD2775]

Thanks Comment. I was pulling the data for the portal from the wrong table. Makes sense.

Yea, in hindsight this is not the best way to structure this particular DB, but it works for what it is intended for and complex reports are not needed. Basically as long as the data is "in there" thats all they care about.

Thanks again