I have a db that is used to record survey results. Several of the fields that get filled in, are drop downs. For instance, we record what Language tours are conducted in. The drop down lists 5 possible laguages. I want to generate a report that allows me to input a date range, and then gives me a list of the # of tours in each of the 5 laguages. Also, I have a field in which we record the membership number of visitors if they are members, and leave this field blank if they are not members. I need to again, after entering a date range, determine the total number of members visiting and the total number of non members visiting base on wether the membership number field is filled in or not. Thanks for any and all help. (See the attached fmp file.)

GR_Surveys_Report.zip

I would suggest either post an unlocked copy or post the key.

Someone will probably want to look at your tables and relationship graph to best answer your question.

K