Hi
I am trying to lookup the Company Name in a query called Qry_MonthlyGPForecastCombined, from a query called Qry_WIPReport, where the Line ID in Qry_MonthlyGPForecastCombined = Line ID in Qry_WIPReport. If the line IDs match, it means that the Company is showing on the forecast report.
I have created a column with the following details:
ShowingOnForecast: DLookUp("Company Name","Qry_MonthlyGPForecastCombined","Line ID=" & [Line ID]).
However, when I run the query I receive #error in each row. Can someone tell me what I am doing wrong.
Kind Regards
Nick
I am trying to lookup the Company Name in a query called Qry_MonthlyGPForecastCombined, from a query called Qry_WIPReport, where the Line ID in Qry_MonthlyGPForecastCombined = Line ID in Qry_WIPReport. If the line IDs match, it means that the Company is showing on the forecast report.
I have created a column with the following details:
ShowingOnForecast: DLookUp("Company Name","Qry_MonthlyGPForecastCombined","Line ID=" & [Line ID]).
However, when I run the query I receive #error in each row. Can someone tell me what I am doing wrong.
Kind Regards
Nick