I have a query where I want lookup a field in a reference table.
tbleRef
Wave
Type
Out
TblA
Nets
Waves
Sub
I am trying to do something like this:
TblRef.outCode:SELECT tblA.Waves, IIf([Nets] Like "*" & [Type] & "*",[Out],"") AS [Output] FROM tblref LEFT JOIN tblA ON tblref.Type = tblA.Waves WHERE (((tbla.WaveForms)="VHF"));
CMD
FS
Fires
F1..........................
I have tried right/left/inner join but get multiple outs for the same row
What I am attempting is to look at a part of tbla.Nets field where it is like one of the rows in tblref.type and display tblref.out