Permanently engage filters

[Rick M]

I am trying to create a report that displays only current data rows. I have created a field with a check box. If the box is checked I do not want it to appear in the report. I wish to keep the data as it may be required in the future. I can establish a filter but it is not permanently engaged. How do I make it permanent?

[CJ_London]

I can establish a filter but it is not permanently engaged. How do I make it permanent?

by using it in your recordsource as criteria

I have created a field with a check box. If the box is checked I do not want it to appear in the report.

I presume by 'it' you mean 'field' and I presume by 'field' you mean 'control'. In the onformat event of the section of the report that that the control is in use something like

me.controlname.visible=not me.checkboxcontrolname

substitute with the names of your controls

[Rick M]

I am actually working in a query file trying to filter the information before I generate a report. By 'it', I am referring to whether the check box is checked. If the box is checked then I do not want the record to proceed further in to the report. I am presently teaching my self how to use ACCESS. As to the rest of your reply I do not understand, may apologies for my lack of knowledge. And Thank you

[CJ_London]

OK - I don't understand the requirement - please clarify what this means

If the box is checked then I do not want the record to proceed further in to the report

does mean you don't want that record to appear in the report? or do you mean only process the records until a record with a tick is found? or something else. Perhaps provide some example data and the required result as an example

[Rick M]

OK - I don't understand the requirement - please clarify what this means

does mean you don't want that record to appear in the report? or do you mean only process the records until a record with a tick is found? or something else. Perhaps provide some example data and the required result as an example

Hello Ajax

Hopefully you can see the attachment clearly. I am the catering manager on an oil rig at sea and our present ACCESS system of managing data is full of errors, so I have taken it upon my self to learn ACCESS and create a new booking system.
I have created a check box with a field name of TERMINATED. I wish to use this so when I call up crew 1 only the present crew 1 people are displayed. I wish to keep the record in the system because people may return to the rig from time to time. When I use the regular filter tool it works but soon close the program the filter is lost.

[orange]

In your query, try

WHERE Terminated <> True

if you need additional criteria, then please tell us in simple terms "who should be selected to meet your requirement".

ONBoard and Not Terminated?

You could post a copy of the database (remove confidential info and/or anonymize data).

[CJ_London]

so to clarify - from that data, you only want to see Tormod and Sherine

if that is the case then in your query, in the terminated column, on the criteria row put the word

False

if your query has criteria on more than one row, you will need to put false on each row

If my understanding is incorrect, provide an example of of the output required and the logic you are using. Also provide a copy of the sql (go the the sql window (see the view button) and copy the sql text, then paste it to this thread

[Rick M]

Thank you for your reply. I works perfectly.

I guess I will be back when with my next problem.

Many Thanks