Search results for query: *

Yes, I know that. So how would the user select all records (as a check box returns a value of 0 OR -1 not both). How does the user select NULL for the check box?

Doesn't help with All records (true or false).

I have a query with a yes/no field in it. I want to create a form for the user so they can either select all the records with the field checked ("yes") or All the records (both "yes" and "no"). They would then press a button to run the query. The query would then pick up its criteria from the...

That is correct. I do have a schema like that. Now, how do you write a query that lists all buildings that have loading docks and fenced compounds? PHV has given me a solution. Is the a better way?

Not really. A building can have 0,1 or many building attributes related to it. There are other fields on the building attribute table. A building attribute record relates to one and only one building (hence the building_Id field on the Building attribute table. I do have an attributes table...

Thanks - thats all I needed.

I have a one to many relationship between a building table and a building attributes table as shown below: BLD_ID BLD_NAME 1 Warehouse1 2 Warehouse2 ATTRIBUTE_ID BLD_ID ATTRIBUTE 1 1 Loading Dock 2 1 Fenced Compund 3 2...