Control query output on autonumber field in table

[stanley2106]

I'd like to add a control to a query so that any records previously output by the query are ignored and only records added since the last time the query was run are shown.

I have an autonumber field in the table and at present can amend the query prior to running changing the Between and And values in the design view but I'd prefer to remove this for the end users.

E.G. If I run the query today and have 100 records in the table I'd expect to have autonumbers 1-100 output, if I run the same query next week I'd expect autonumbers 101 to whatever is the last record in the table.

 

[BNPMike]

I don't think you can add a control to a query.

You seem to be wanting to run a query and then update a table to mark selected records.

You could try a stored procedure. An other way is to run the query from a form and then attach a leave-form event which runs a query to update a suppression field using the same logic and values as the select query. You assume both queries would select the same records.