Report -> vælg dem hvor yes/no felt er lig 1

SELECT * FROM tblmedlemmer WHERE YesNoFeltet = -1

you can do this in the query builder. Then when the query is made use this in the report.

jeg kan godt sql, jeg skal bare vide hvor henne af jeg skal skrive den

In the database window press the Queries button, then press New. Choose Simple Query Wizard from the list. Now find your table from the combo (list) and choose the fields you want in the query. You can now select FINISH. The query will now be shown in Data Sheet View. Now right click on th eblue title bar at the top of th equery window and choose Query Design. Now in the Criteria Field for the Yes/No field enter True (This is the same as -1)

Now you save the query and use this in your report

tak terry, det var det jeg skulle vide...

You can also Choose Queries+New+Design View. Then choose the table from the list and then close.
Now right click on the blue title bar and choose SQL View. You can enter the SQL here and then again right click on the title bar to choose another view.

OK, thanks :o)