Duplicate numbers, but different criteria

Hi i am back,

I have two linked excel tables, they both have a part
number & its level e.g. 1234567-01.
The second table sometimes hase two of the same part
number but different levels e.g. 1234567-00 & 1234567-01.
My problem is that i want the query to to find the same
criteria e.g. 1234567-01 is in tbl1 therefore it must see
the same number if it is in tbl2.
Is this possible?
Sorry i am quite new to the game!

snip
I have two linked excel tables, they both have a part
number & its level e.g. 1234567-01.
The second table sometimes hase two of the same part
number but different levels e.g. 1234567-00 & 1234567-01.
My problem is that i want the query to to find the same
criteria e.g. 1234567-01 is in tbl1 therefore it must see
the same number if it is in tbl2.
Is this possible?
Sorry i am quite new to the game!

you need to modify the criteria like this:
if numeric -
"[partnumber] = " & Left(Me.field, Instr(1,[partnumber],"-")) & "*"
if alphabetic
"[partnumber] = " & Chr(34) & Left(Me.field, Instr(1,[partnumber],"-")) &
"*" & Chr(34)

To find an example of how to use the criteria, create a form with table one,
and a command button through the wizard. In the wizard choose form
operations - open a form - find specific data and the skeleton code will be
setup.

So far as I know the form/subform won't work unless you go another route of
also storing the 'parent part number' on each table ie the part to the left
of the dash, and they can relate on that.

Marc

Thanks Marc
-----Original Message-----
snip
I have two linked excel tables, they both have a part
number & its level e.g. 1234567-01.
The second table sometimes hase two of the same part
number but different levels e.g. 1234567-00 & 1234567-
01.
My problem is that i want the query to to find the same
criteria e.g. 1234567-01 is in tbl1 therefore it must
see
the same number if it is in tbl2.
Is this possible?
Sorry i am quite new to the game!

you need to modify the criteria like this:
if numeric -
"[partnumber] = " & Left(Me.field, Instr(1,
[partnumber],"-")) & "*"
if alphabetic
"[partnumber] = " & Chr(34) & Left(Me.field, Instr(1,
[partnumber],"-")) &
"*" & Chr(34)

To find an example of how to use the criteria, create a
form with table one,
and a command button through the wizard. In the wizard
choose form
operations - open a form - find specific data and the
skeleton code will be
setup.

So far as I know the form/subform won't work unless you
go another route of
also storing the 'parent part number' on each table ie
the part to the left
of the dash, and they can relate on that.

Marc


.