Hello all, my database lists parts that have the following fields (amongst
others),

BOM
TIME
PRICE
CABLES
CUSTOMER
PARTNUMBER

I would like to use a query that will return all records that are similar to
a PARTNUMBER i enter. The query would search the records and return only the
if the record has the following criteria;

CUSTOMER is same as CUSTOMER in the PARTNUMBER i enter.
BOM is within + or - 10% of the BOM on the PARTNUMBER i enter.
TIME is within + or - 10% of the TIME on the PARTNUMBER i enter.
PRICE is within + or - 10% of the PRICE on the PARTNUMBER i enter.
CABLES is within + or - 10% of the CABLES on the PARTNUMBER i enter.

I have managed in the past to enter each individual criteria (BOM,TIME Etc.)
and return records but i am struggling to be able to enter a PARTNUMBER and
have the records returned according to the above criteria.

I would very much appreciate any help on this query.

The query results will be used for a report.

many thanks