> On 2014 Nov 22, at 02:57, Tami Williams <[log in to unmask]> wrote:
> 
> I have a Filemaker 11 database with People related to Conference Registration.
> 
> 1 person may have 1 or more conference registration records.

Need more detail here. Do they have just 1 registration record PER YEAR, or can they have multiple registration records in a single year (say, 2 1-day-only memberships instead of a single full-week membership, or perhaps a separate registration for a banquet in addition to a general membership)?

> What is the best way (calc/script) to answer this question:
> 
> 
> What percent of people attended the 2010 and 2012 conference?

Do you mean how many of the 2010 attendees also attended the 2012 conference, divided by the total 2012 attendance? Or the other way around?

> (Note: the user would pick a series of years (2-4) and want the percent that attended all)
> 
> 
> Thanks in advance.