I'm using access 97. My report is printed from a query. This query contains a field named Hazardous which is a check box next to another field named chemical. I have about 25 records of chemicals and about 4 of them are Hazardous so the check box next to the 4 chemicals is checked. Okay, so on my report I have a cover page which states building information and then behind that I have the 25 chemical records listed. Anyways, on the cover page I have a check box which I want to be checked if any of the 25 chemicals are checked. In this case there are the 4 chemicals, so is there a way to write a code maybe that determines if any of the 25 records are checked and if so place a check mark on my report...
Hope this is enough info...
Gustavson
Hope this is enough info...
Gustavson
