Selection criteria comparing values in two fields

[newtond]

This maybe an easy fix, I'm not sure, but here goes>
I am preparing an Inventory report and have defined the fields I need from an SQL databse. I have run the query to get the basic data. What I effectively need the final report to do is display only the records where:

"For a given item in stock, the Value in Field A is between the value in Field B and Field C".

Can anyone suggest a formula to do this please?

 

[MrBillSC]

In your record select formula enter:
FieldA > FieldB and
FieldA < FieldC

MrBill