Okay, I did this both ways in the hopes that one would be correct. I have attached bitmap file & I created a query using the instructions in the "Forum Etiquette" to produce the data below
SELECT "7","2012-03-01","Audit","Alcohol1-001","0" UNION ALL
SELECT "7","2012-03-01","Audit","Alcohol1-001","0" UNION ALL
SELECT "8","2011-08-09","Audit","Alcohol1-001","0" UNION ALL
SELECT "8","2011-08-09","Audit","Alcohol2-002","0" UNION ALL
SELECT "8","2012-01-11","Audit","Alcohol1-001","0" UNION ALL
SELECT "8","2012-01-11","Audit","Alcohol2-002","0" UNION ALL
SELECT "9","2011-08-24","Audit","Alcohol1-001","0" UNION ALL
SELECT "9","2011-08-24","Audit","Alcohol2-002","0" UNION ALL
SELECT "9","2012-02-18","Audit","Alcohol1-001","1" UNION ALL
SELECT "9","2012-02-18","Audit","Alcohol2-002","0" UNION ALL
SELECT "12","2012-02-14","Audit","Alcohol1-001","0" UNION ALL
SELECT "12","2012-02-14","Audit","Alcohol2-002","0" UNION ALL
SELECT "13","2011-09-28","Audit","Alcohol1-001","0" UNION ALL
SELECT "43","2011-11-01","Audit","Alcohol1-001","0" UNION ALL
SELECT "44","2011-11-21","Audit","Alcohol1-001","0" UNION ALL
SELECT "157","2012-02-29","Audit","Alcohol1-001","0" UNION ALL
SELECT "157","2012-06-20","Audit","Alcohol1-001","0" UNION ALL
SELECT "158","2012-03-21","Audit","Alcohol1-001","0" UNION ALL
SELECT "158","2012-07-11","Audit","Alcohol1-001","1" UNION ALL
SELECT "160","2012-06-19","Audit","Alcohol1-001","0" UNION ALL
SELECT "160","2012-11-09","Audit","Alcohol1-001","0" UNION ALL
SELECT "164","2012-07-17","Audit","Alcohol1-001","0" UNION ALL
SELECT "174","2012-06-06","Audit","Alcohol1-001","1" UNION ALL
SELECT "178","2012-07-17","Audit","Alcohol1-001","0" UNION ALL