Hi,
I have a table (codpers, codmateria, notes1, notes2)
I have a string variable
FILTER = "codpers = 1234 and codmateria = 456789"
I want to create an index (note_ind) of two fields - codpers and codmaterials - for use in a Dlookup
as follows:
Dlookup ("note_ind", "table", "FILTER")
Thanks