It sounds as if you are using the query design view (the query grid) to
build your queries.

Open a new query
-Select your table
-Click close
-Add the fields to the query grid
-under part number enter
= [What Part]

Save this query as qPartMatch.

Open a new query
-- Select your table
-- Click on the query tab
-- Select the saved query
-- Click close
-- if there is no join line between partNumber and PartNumber Drag from the
table to the query
-- if there is no join line between Customer and customer drag again
-- Add the fields you want from the table
-- in the criteria under the relevant fields you will have to type
BETWEEN [qPartMatch].[BOM] *.9 And [qPartMatch].[BOM]*1.1

Alternative is to copy the proposed SQL statements into the SQL view of the
query and edit the table (and field) names. Save the first as noted.

Now copy the second one as posted and change the table name again.

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

"Maax" wrote in message
...
Hi John, many thanks for reply.
I have a minor problem, i am very novice and although i can create basic
queries i am unsure where to enter the following,


SNIP