0

I have made this work before, but I can not find it and do not remember how.

SELECT tblMyData.ID, tblMyData.LineNum, tblBudgetRange.[Budget Name] 
FROM tblMyData 
INNER JOIN tblBudgetRange 
ON tblMyData.LineNum Between ([tblBudgetRange].[fromLine]) And ([tblBudgetRange].[toLine]);

I also tried DLookUp("BudgetName","tblBudgetRange", [LineNum] & "Between fromLine and toLine".

GMB
  • 216,147
  • 25
  • 84
  • 135
Joel
  • 1
  • Please tag your quesrtion with the database you are running: mysql, sql-server, oracle...? – GMB Nov 18 '22 at 22:27
  • You would probably also need to show some sample data and desired results (as tabular text), and help us better understand your problem. What happens when you run your code? What is not working as you would like? – GMB Nov 18 '22 at 22:28

0 Answers0