I have a table which displays the daily log on's of approximately 20 users.
I want to run a query that when I enter a date shows all the users that WERE
NOT logged on for that particular day.

For example, say user id's 1 and 2 were on the system on a particular day
but user id's 3 - 20 were not. How do I display just the remaining 18 users
without displaying all of their log in details for the remaining dates
included in the table, as currently happens when I run the query using the
Not Like (date) function in the query design grid.

I also have a separate table which lists the 20 users names, user id's and
other miscellaneous data.

Many thanks

Hi:
Use the query you have written.
Right click in an empty area where the tables are shown. Choose
properties. Set Unique Values to "yes".\
You should then see only one record per user. If all you deisplay is
the user name your work is done.

Good luck

Ira Solomon

On Wed, 08 Sep 2004 05:50:17 GMT, "Andy Davis"
<ad_davis12 (AT) bigpond (DOT) com> wrote: