Criteria for multiple (>9) checkbox statuses in a query

[Beemerang]

Hi All

I need to design a query that contains about a dozen fields for stationery items along with another dozen fields (checkboxes) to show whether these items were delivered (Yes, I know, not great db design).

I ran out of space with the the query criteria window, any tips on a more elegant way to do this?

Many thanks,
Beem

 

[Mile-O]

For elegance, I think you said itself. The design is the problem. I take it that it's too late to change this and get the structure right?

 

[Beemerang]

Hi Mile-O,

Thanks for responding. As always, there is too little time and too much to be done. If there is no other way, I'll probably have to redesign.

Beem

 

[Mile-O]

You could probably do something with UNION queries. Can you be more detailed in your field names?

 

[Beemerang]

Great idea! Let me do some reading and get back to you if I get stuck?

Thanks mate!

Beem

 

[Galaxiom]

I ran out of space with the the query criteria window,

More rows and columns can be added. In 2007 onwards they are buttons on the query Design Ribbon.

 

[Beemerang]

More rows and columns can be added. In 2007 onwards they are buttons on the query Design Ribbon.

Thanks mate!

Beem