I'm used to vlookups in excel, but it does not seem so easy in access. I'm trying to add a column in a query using a dlookup. I have brought in two tables T1 has all possible ID numbers and the business names, T2 has the expenses by ID. I want a formula that give me the business name in a column in my query. In simple terms: lookup the id in t2 row, t1, should give me the business name.
Bookmarks