Schema

[Guest]

I made a schema, I will like to make a button which is gonna work like when a
deal has expired I can mark it. And it has to work like the deals that are
marked wont be showed at the report I want to print out.

Need some adivices here :=)

 

[Rick B]

I would just add a checkbox to the table called "expired" and check it for
expired deals. Or, better yet, add an "ExpiredDate" field and enter the
date when something expires.

To remove these from your reports, just adjust the query that pulls the
records to the report. In your query, under your new field just put
something like...

False

if you use a check box (true/false) field.

or, if you use a date, use something like

Null