Search results

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

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

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

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

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?

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

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: