Search results

  1. N

    MS Query DLookup not returning desired results when looking up text

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

    Question MS Query DLookup not returning desired results when looking up dates

    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...
Back
Top Bottom