Counting Unique entries

[hazell]

Good Morning,
I have a database which records the number of people who attend a number of different sessions in a week, and I have a query which counts the number of people who attend the sessions in a quarter. This gives me the total number of attendees, but I also need to count the number of individual people - some people go to more than one event. I think I need some sort of DCount expression, but am not sure where to put it. I have two tables that I am using - one called People and one called Provision. the Provision table selects the attendees from the People table. Any ideas?
thanks

 

[hazell]

I think I made an error when I set this db up, because I thought I was being clever in using multi-values to select the people who attended the provision. now it is making creating the queries really really difficult. I can get a list of people who attended each provision, but it is one long string seperated by commas. I don't seem to be able to get the query to treat these as seperate pieces of info, if you know what I mean. Any ideas?

 

[arnelgp]

use the fieldName.Value in your query.