The short answer to your question is No. You can't find all records and
display them in a query if they have not previously been displayed in the
query. A record is not marked by a query as having been viewed.
How would Access know which records had been viewed by which queries and
when? Keeping track of that internally would be an incredible task and
would not be needed in most cases.
You would have to mark records if they were inculded in a run. Then you
could pull records that were not marked. You would then have to mark them.
Several ways to accomplish this, but none that can be easily done by running
one query.
Rick B
Hello,
Can ANYONE supply an example of a query that only displays NEW data that has
been added since the last run???
Charles L. Phillips
