Creating a search, amount > $$ and < $$$

[FM7Newbie]

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

[Alan H]

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?

[dkemme]

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.

[RalphL]

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