I need to use the result of a query as a lookup field for another query. What I tried was using a sub query aliased as something, but finally I got some error saying "enter parameter value" for
I've searched in forums, but I can't find any similar problem.
SELECT sahmeharkas.attrib, [sahmeharkas]![expenseper] AS Expense, variz.variz FROM sahmeharkas LEFT JOIN (SELECT variz.varizname FROM variz GROUP BY variz.varizname) as Y ON sahmeharkas.attrib = Y.variz.varizname