Duplicate numbers, but different criteria

  • Thread starter Thread starter Les
  • Start date Start date
L

Les

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!
 
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!
Click to expand...

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-----
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!
Click to expand...

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


.
Click to expand...
 
Back
Top