ASP/SQL question -
(Different form from the one mentioned above) The form being used is for a call center which has close to 50 checkboxes of things that could be sold. The idea behind this is for the user to check the box indicating a sale. The data input team will then need a form which will display each sale in a list. I can use IF statements all day and make this work but it doesn't seem like the best way to approach this project. Any other solution or suggestion would be very helpful.

My Assumption (SQL pulls all data where status = 'Open'... then it will only display the field names where rst.field.value = 'True' (Yes/No Field in Access). I am assuming this can be done but I can't find documentation showing me the process.)

Thanks for any help.

Art