Jump to content

Search based on >$$ and <$$$


This topic is 7285 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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.

Link to comment
Share on other sites

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

Link to comment
Share on other sites

This topic is 7285 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.