I need to automate a search.

I have a Donations layout with donation date, donorName, donorID, amount given, etc...

I need a search that will show all records based on amount given every year for last 3 years from user inputted amount.

So, the query would automatically check current date and then look back 3 years, and display everyone who has given say between $100 and $500 every year since 3 years ago.

So all the user would input would be the $ parameters of the search, like

amount > $500 and < $1000.

I hope this makes since.

I would greatly appreciate any help in this task.

FileMaker Version: 7

Platform: Windows XP

Why not ask them to learn FM Pro's special search characters?

Hit Command-F, Put "500..1000" in the "Amount" field, "?1/1/2001" in the "Date" field, and hit return

Or am I missing something?

I wonder if you could create a layout with a couple of globals that the user could enter the criteria. Then create a script the layout would call that could enter the values of the global formatted into FM Pros special search characters and perform the find.

This would be an ideal case to use the Relationships > & < and GTRR show. 4 relationships ANDed should do this.