We have been using FileMaker Pro for our Bed &Breakfast's reservation system since 2005 and have updated it over the years and currently are using File Maker Pro 10.0v3.

We have an "Arrival" and a "Departure" field that is "date" type in format "month/date/year" and a Comments field that is "text" type.

We want to "find" all of the guests who stayed with us over the years in November and celebrated their Anniversary with us so on so we can send out advanced congratulation letters (You know help the guy remember!).

Searching Comments field for "Anniv" is no problem, but going thru hundreds of records and omitting all other records with "Anniv" in the Comments field that are not November Anniversaries is tedious. Yea, I know the comments field should have had "November Anniv," but I wasn't that smart in 2005.

We want to consolidate all of November 2010 Anniversaries with November 2009 Anniversaries with November 2008 and so on, so we can send out advanced congratulation letters.

We tried entered ">=11/##/## <=11/##/## in the Departure field, in addition to "Anniv" in the Comments field, but get an "invalid" search criteria.

Is there a way to:

Search for "November" only and get all seven years of November Anniversaries?

or

Can we search ">=11/1/05 <=11/30/05 in the Departure field and "Anniv" in the Comments field and then add those results to a new search ">=11/1/06 <=11/30/06 in the Departure field and "Anniv" in the Comments field year so that we end up all November Anniversaries in one find and use a layout to printout letters?


Sincerely,
George & Hanneke Ware
Innkeepers

The Chalet Inn Visit us Online at: http://www.ChaletInn.com
285 Lone Oak Drive (828) 586-0251 / (800) 789-8024
Whittier, NC 28789 mailto: ParadiseFound@ChaletInn.com






#############################################################
This message is sent to you because you are subscribed to
the mailing list FMPro
FMPro@lists.lassosoft.com
To unsubscribe, E-mail to: <FMPro-unsubscribe@lists.lassosoft.com>
Send administrative queries to <FMPro-request@lists.lassosoft.com>