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 variz.variz and Y.varizname.
I've searched in forums, but I can't find any similar problem.
Code:SELECT sahmeharkas.attrib,
Code:[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