Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
MS Access Queries - Passing a Yes/No value from a form to a query
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...- belangerg
- Thread
- Replies: 5
- Forum: Microsoft: Access Queries and JET SQL
-
Access query on 1 to many relationship
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...- belangerg
- Thread
- Replies: 7
- Forum: Microsoft: Access Forms
