How to Determine Who Has Not Done Something

  • Thread starter Thread starter Frolickin
  • Start date Start date
F

Frolickin

I have a table:
autoID, personname, event, eventdate

I have queries of this table to count events, determine who has done what
and when, etc.

One query I made queries this table and another that includes more
information about the event, including the county the event took place:
autoID, personname, event, eventdate, county

I created a query that determines for each personname, the events he has
attended in each county.

What I am struggling with is creating a query that determines for each
personname which events he has not attended in each county.

How would I go about creating this?
 
Unless you have a "person" table that lists persons, I don't see a way for
you to see persons without events...

And your description of the two (?) tables sounds like you've duplicated a
lot of information -- any chance this used to be an Excel spreadsheet?
 
I do have a persons table. The "problem" arises that the person table
includes quite a large population in comparison to the sub-group of person
who have events in a specific county. All I would be interested in knowing
is for those who have events in a county, which events have they not
completed?

I think I did not write my description very clearly. The two tables repeat
only the evetname. It is the resulting query that repaeats the data. Sorry
for the confusion.

persons table includes personname
event table includes eventaname, county, etc.
eventcompleted table includes personname, eventname, and date event was
completed

I have a query that results with personnames, eventnames, and the county the
events took place.

I am trying to create a query that lists those events which a personname has
not completed in a county. Whether the personname completed a task already
or not in the county is not important, unless it is easier to exclude those
who have not (would that make the query more efficient?).
 
Afraid I still do not understand. How is a person associated with an event
(?or a county), but hasn't been shown to complete that event?

I'm asking because Access offers an "unmatched" query wizard, and I suspect
that if you have a table somewhere that lists all relevant folks
(?county-related; ??county-event-related), you could use the unmatched query
wizard to compare that list with the persons-completing-event list.
 
I guess I am not explaining my need well. For that, I
apologize.

personname table: personname
event table: eventname, county
eventcompleted table: person (linked from personname
table), eventname (linked from event table), date

eventcompleted query: lists those individuals who
completed events, when they completed them, and which
county the event was held.
ex.
John Event1 1/1/2004 Sussex
Mary Event1 2/1/2004 Sussex
Bob Event2 1/15/2004 King
Joe Event1 2/14/2004 Sussex
Joe Event3 3/1/2004 Sussex
etc.

What I would like to do is generate a query that lists
all personnames and the eventnames (and counties those
events are in) that all personanmes have not completed.

Ex.
John Event2 King
John Event3 Sussex
Mary Event2 King
Mary Event3 Sussex
Bob Event1 Sussex
Bob Event3 Sussex
Joe Event2 King
etc.
-----Original Message-----
Afraid I still do not understand. How is a person associated with an event
(?or a county), but hasn't been shown to complete that
Click to expand...
event?
 
What I would like to do is generate a query that lists
all personnames and the eventnames (and counties those
events are in) that all personanmes have not completed.
Click to expand...

So it sounds like you are asking for a list of persons who are NOT in the
EventCompleted table.

But earlier I believe you mentioned that you have a large number of persons
in your person table, and don't want to see all of them.

My question stands -- how do you keep track of persons who SHOULD be in
events? That's the table against which you'd use the "unmatched" query to
find those who are not in EventCompleted.
 
Back
Top