create query to select records

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a yes/no field (checkbox) in my main table which is called hardware. I
want to create a query that will select records for which this field is true
and either put it in another table or to have another form that will show
only these records in which are true. Also just in case, i would like to be
able to move them back to the hardware table by unchecking the checkbox. Any
ideas??
 
Hi, Alfred.

Sure. Click on New from the Queries tab to start a new query, and show the
table(s) you're interested in. Drag the fields you need to the query grid.
In the Criteria row of the checkbox field, type True. Press the DoIt button
(the exclamation point) to execute the query. Verify that you're getting
what you wanted, and save it.

Now, create a form that is based on this query. When you open the form it
will only display the records that the query selects.

Simply click off the checkbox to "move" it back into the Hardware table
(you're not actually moving it anywhere).

Hope that helps.
Sprinks
 
Back
Top