Search based on >$$ 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.

[stanley]

The format for that find (in your example) would be "500...1000". The "..." indicates "everything between". You could have two global fields that the user types into, then construct your find from them...

-Stanley