# Recent content by Humpty

1. ### 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. ### 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. ### 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. ### Output Direct to PDF from VBA

Also worth having a look at this Steve: http://www.lebans.com/reporttopdf.htm
5. ### 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. ### 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. ### 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: