----- Original Message ----- From: "Allan Raymond" <allan_raymond@btinternet.com> To: <FREEBMD-DISCUSS-L@rootsweb.com> Sent: Thursday, February 05, 2004 12:55 AM Subject: Re: Latest update > Your explanation has almost clarified it for me. > > Without complicating the issue and to get a better understanding, under what > circumstances would the number of distinct records be greater than the > number of unique records? > > The Database statistics in general for each year/event shows the number of > distinct records to be greater than the unique records. I got my terms wrong! Switch distinct and unique in my explanation, and it should make sense :-)