Only returning >20% profit results

[BWGies]

Having trouble figuring out the way to get my results.


Looking to get a query that includes a few fields but only show orders with >20% profit margin.
I am also having an issue with getting results that included a specific item in the sale. When I put in "item" for example the results would change orders to show everyone buying said item.

Any help would be great.
Thankyou

[Minty]

I think you will need to show us what you have tried, or some example starting data, and what you the expect to return from it.

We would be guessing a lot without some other information.

[Homegrownandy]

For displaying the results per item, one way you could achieve this:

Have a combo box on the form displaying all items then write a query (prehaps for a subform) that references the combo box choice.

Make sure you have a requery on the update event of the combo box.

The Criteria in the query would be =form!form_name!combobox_name.

Just as a point. It may be better to seperate two unrelated questions into two threads to avoid confusion in the answers.

Andy.