Search results

  1. H

    Simplify calculation

    Hi all. I was wondering if anyone might be able to help me simplify the following that I am using to calculate a value on one of my forms: =(Iif (IsNull([txt24Calc]),0,[txt24Calc]))+ (Iif (IsNull([txt27Calc]),0,[txt27Calc]))+ (Iif (IsNull([txt30Calc]),0,[txt30Calc]))+ (Iif...
  2. H

    Date criteria in a query

    Wonder if anyone can help with the syntax in this query? It always returns no results and I can't for the life of me understand why. SELECT tblExpectedShipments.ShipmentDate FROM tblExpectedShipments WHERE...
Top Bottom