Using MS Access 97 how do you create a query that would produce a word instead of true or false (I will be using this to populate an Access report. I have three fields (laborer, carpenter, other). Laborer and Carpenter are yes/no fields, and other is text. I'd like to create a report showing a field for TRADE and under that field display Laborer if the laborer field is a yes, or show Carpenter if the carpenter field is a yes, or display what is in the other field if there is something in it. It should also display any combination (example: If Carpenter is a yes and Laborer is a yes and there is something in other display
Blah Blah Blah.