Search results

Hi CJ / Minty CJ - Unfortunately, that came up with the same error. Minty - thanks for you suggestion, this worked. I am still learning so your advice and suggestions are most appreciated. Thank you Kind Regards Nick

Sorry CJ. It returned #error in each row.

Hi CJ ShowingOnForecast: DLookUp("[Company Name]","Qry_MonthlyGPForecastCombined","Line ID=" & [Line ID]) didn't work. Kind Regards Nick

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...

Hi CJ_London That worked. Thank you, you are a star. Regards Nico

Hi I am using Dlookup in a Query and it's not showing the desired results when looking up dates i.e. some fields are showing the correct month, some fields are blank, and other fields are showing the incorrect month. I have created a union query called Qry_Commission_Export that includes a...