Multiple Boolean in Query Problem

[lacharnold]

I have created a register as a query and have three different time slots that can be taken up, 1 hour, 2 hours, 3 hours. Each record only has one selected via Boolean. I want to create a query with all three different times shown with all records that have selected a Boolean. But when i set each as true they all seem to cancel each other out. If i set one to true then that 1 hour is shown but the rest are not. Not entirely sure if i have described this correctly but any help would very much appreciated.

Thanks.

[June7]

If each record can have only one time slot then don't use 3 Y/N fields, use one text field with 3 value options.

[lacharnold]

That is beautifully simple, Thank you very much.