Search results

  1. H

    dlookup in query using month/year as criteria

    Decided to go a different route, scrapped the original query with the Dlookup and created a new one, gets the results I was looking for. SELECT * FROM BargeCost, ActFuel WHERE Month(ActFuel.FuelDate) = Month(BargeCost.LoadDate) AND Year(ActFuel.FuelDate) = Year(BargeCost.LoadDate) Case closed...
  2. H

    dlookup in query using month/year as criteria

    Anyone have a solution?
  3. H

    dlookup in query using month/year as criteria

    The table ActFuel fields are: "InputDate", "FuelDate", "FuelRate" I am trying lookup the "FuelRate" for a given month/year from "FuelDate", that I can associate with the "LoadDate" of a shipment to calculate the fuel surcharge. "LoadDate" is a field in the query I am creating based on another...
  4. H

    dlookup in query using month/year as criteria

    This did not solve the problem, running the query returns an error "access cant find the name 'LoadDate' you entered in the expression"? LoadDate is a field in the query I am writing ... epr1: DLookUp("FuelRate","ActFuel","Month(FuelDate) = Month([LoadDate]) AND Year(FuelDate) = Year([LoadDate])"))
  5. H

    dlookup in query using month/year as criteria

    Thanks GanzPopp, I appreciate the insight
  6. H

    dlookup in query using month/year as criteria

    hello, I have a query that I need to look up a fuel rate in a table based on the month and year of the applicable load date. ActFuel is the table, Rate is a number field in table, FuelDate is a date/time field associated with the rate. LoadDate is a date/time field in the query from another...
  7. H

    Hello

    My name is Hunter and I have been access for a couple of years, but I am still learning. I am from the Seattle Washington area and looking forward to participating in the group.
Back
Top Bottom