If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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! |
#2
|
|||
|
|||
Duplicate numbers, but different criteria
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 |
#3
|
|||
|
|||
Duplicate numbers, but different criteria
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 . |
Thread Tools | |
Display Modes | |
|
|