Between Expression searching between alpha / #'s - Using Access Form

Hello,

My name is April and my attempt in Access is to create a form, also
with a command button which will search for information and put this
information onto a label or box on the form.

SEE EXAMPLE BELOW:

OBJECTIVE:
Access will need to search between column 1 / 2 below (after user
inputs drawing number in text box and hit command (search) button and
bring back results of column 3.

(column 1) (column 2)
(column 3)
*Begin Draw No.* *Ending Draw No.* *Shelf Location*
BC-1145.00 BC-1185.00 Shelf 1
BC-1186.01 BC-1258.02 Shelf 2
BC-1298.03 BC-1305.02 Shelf 3


EXAMPLE OF FORM LAYOUT:

DRAWING NUMBER: (TEXT BOX HERE) -- User enters BC-1150.01 (Since
this is between 'BC-1145.00 and BC-1185, would like for Access to
search between this parameter)

SEARCH: (COMMAND BUTTON HERE) -- User clicks on command button to
retrieve information

RESULTS: (LABEL OR TEXT BOX HERE) -- the information now shows
within a text or label box. (via example above, the results would be
"SHELF 1")

Please help. If more information is needed, please let me know.

Thanks!

.