Filtering criteria dealing with max and min fields.

[mejia.j88]

Hello All,



I have a table called BOAT_ID with the following columns:

Min_Size, Max_size, Cut_size and LeadType. First three are numbers, last is text.

I have a cbo cbo_Partnumber in a form that the operator selects the part number from.
it automatically fills in text boxes with info like size, cutsize and lead.

my BOAT ID table only contains ID names for "Boats" used in our process. this table is fixed in size.

My goal: To have a a query called qry_BoatID that will filter table BOAT_ID based on the text boxes mentioned above. I am able to filter for lead type, and cut size.

My Problem: i have an issue filtering by min and max size.

what kind of criteria can i create that will be something like "ONLY SHOW RECORDS OF BOATID WHERE:

StackSize Text Box is between Min_Size and Max_Size.
i suppose i am mostly asking for help with the syntax, and where this should go in my query.


Thank you,
Jorge

[June7]

Create a field in query with an expression:

CriteriaInRange: [Forms!formname.StackSize] BETWEEN [Min_Size] AND [Max_Size]

Then criteria under this constructed field: True

[mejia.j88]

Thanks June7, this worked perfectly.