The question is how to return the text that I want from my parameter? Means I want to look for a certain word in the name of a company and the query will run the companies' name that contain that word.
I don't want to specify the word in my SQL statement I want to leave it open. I've done it with a date and the criteria for the parameter is:
In SQL it's translated like this:
WHERE Table.OrderDate = [Date:]
And I will enter the date that I want. Is there a way to do it with text to return all the companies' names containing the word that I want on my parameter?
Would you know how to return all the records between any values that I would enter?
I have an Order Amount Field and I would like to return all the records between Paramter 1 which is Order Amount 1 and Parameter 2 which Order Amount 2. I want to specify my order amount when the parameter pop up.