Recent content by Humpty

  1. H

    Simplify calculation

    Just remembered the 'Nz' function :cool: That does the job: =Nz([txt24Calc])+ Nz([txt27Calc])+ Nz([txt30Calc])+ Nz([txt33Calc])+ Nz([txt36Calc])+ Nz([txt39Calc])+ Nz([txt42Calc])+ Nz([txt45Calc])+ Nz([txt48Calc])+ Nz([txt51Calc])+ Nz([txt54Calc])+ Nz([txt57Calc])+ Nz([txt60Calc]) Thanks...
  2. H

    Simplify calculation

    Thanks for the swift response phatnq2002. The form does have a record source but as mentioned the txt..Calc controls are calculated and the calculation is based on user input (into bound controls on the form). I don't think there is a way to simplify this using a query. It all works, I was...
  3. 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...
  4. H

    Output Direct to PDF from VBA

    Also worth having a look at this Steve: http://www.lebans.com/reporttopdf.htm
  5. H

    Date criteria in a query

    Thanks workmad. It looked like it could be a possible solution but afraid it just returns the error "The expression you entered has and invalid date value". Any other thoughts?
  6. 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...
  7. H

    Need help with report footer

    I would also be interested in a solution to this. How can you force the report footer to appear at the bottom of the last page (not immediately below the end of the report data)? I have been looking for a solution to this for ages. :eek:
Top Bottom