I have a used the Instr and mid function to extract parts of records then linked the extracted part to another table column.
e.g.
Table1
-manufacturer
-model (primary key)
-picture
Table2
-Description (imported weekly)
Query1
-Description (taken from Table2)
-Mid(InStr – used to get Model from the description
Query2
- model (from Table1 and linked to Query2)
- manufacturer (from Table1)
- picture (from Table1)
In Query2 I have linked the Model columns from both tables together which does match the manufacturer and picture fields to the model from table2 but then displays “Invaild procedure call” and all data in the fields is changed to “#Name?”.
How do I fix this problem or is there another way round?
Any help will be much appreciated
e.g.
Table1
-manufacturer
-model (primary key)
-picture
Table2
-Description (imported weekly)
Query1
-Description (taken from Table2)
-Mid(InStr – used to get Model from the description
Query2
- model (from Table1 and linked to Query2)
- manufacturer (from Table1)
- picture (from Table1)
In Query2 I have linked the Model columns from both tables together which does match the manufacturer and picture fields to the model from table2 but then displays “Invaild procedure call” and all data in the fields is changed to “#Name?”.
How do I fix this problem or is there another way round?
Any help will be much appreciated
Last edited: