New federal guidelines require that ethnicity is separated from race. No biggie. Our ERP vendor supplied the collection tool, stuck the data in a table. They updated their existing reports to use the new format, but have gone no further. I need to pull the information from their table for ad-hoc and regularly required reports.
Without going into details, no, we cannot change vendors and no they do not support us properly.
Long story short, I'm using a mix of Access 2007 and 2010 to pull info. We have the following table layout in a non-DB2 database on an AS/400 ( other technical details not important?):
Each field is basically just a one character Y/N field (not 1/0, Y/N . hah).
Now, I need the data in a format that will complete the attached chart. This will be the "new" way we will be pulling this type of info and we do it a LOT, so I need it to be as easy as possible. The big hangup is multiple race. Before, when we didn't record multiple race, this wouldn't be too hard, but now, I'm stumped. If I were doing this in PHP, I could do it easily with a few nested arrays and counting. I'm not advanced enough in MS Access to do this, so I turn to you guys! Any assistance is appreciated.