Hello All,
I am trying to build an query with a dlookup with the criteria being a column within the query.
for example,
I have a query that has following columns: Testing Month, Question, QuestionID, Total Fails: Dlookup(Column)
example of current query dlookup: Total Fails: DLookUp("AT01","Copy Of Qryrpt_MysteryShopper_AnalystDashboard","[Testing Month] = 'June 2016'")
So i would like the dlookup criteria to lookup the "Testing Month" instead of me actually placing the testing month in the criteria. The testing month is the column i want to lookup which is within the same query with the dlookup.
Any help would be appreciated.
I am trying to build an query with a dlookup with the criteria being a column within the query.
for example,
I have a query that has following columns: Testing Month, Question, QuestionID, Total Fails: Dlookup(Column)
example of current query dlookup: Total Fails: DLookUp("AT01","Copy Of Qryrpt_MysteryShopper_AnalystDashboard","[Testing Month] = 'June 2016'")
So i would like the dlookup criteria to lookup the "Testing Month" instead of me actually placing the testing month in the criteria. The testing month is the column i want to lookup which is within the same query with the dlookup.
Any help would be appreciated.