| | |
|
|
|
Count |
|---|
| message from =?Utf-8?B?YW50aG9ueQ==?= on 11 May 2004 |
Okay, I have a quick question. I have a summation query, where it's supposed to count how many people are attending an event. When I use just the attendance table, where I did a group by using the conferenceID and count the PersonID, I have 80 people. However, if I link the attendance table with the person table, I get 79, which is the correct count. Does anyone know why?
|
| Kailash Kalyani replied to =?Utf-8?B?YW50aG9ueQ==?= on 11 May 2004 |
Both could be correct. It may be that one of the personIds from the
conference could've been deleted from the Person table.. if you have
referential integrity off that can easily happen.
|
| =?Utf-8?B?YW50aG9ueQ==?= replied to Kailash Kalyani on 11 May 2004 |
AHA! Thanks!
|
|
Archived message: Count (Microsoft Access Error Message)
