Hello again..... still can't get this report right 
I have a textbox in the body of my report called "QualShip". The control source is :-
=IIf([Qual]="Y",([ShipFig]),0)
This works fine. If the trip is within tolerance the value of [ShipFig] appears in [QualShipFig], otherwise it shows zero. So far so good. But... in the report footer I have a textbox called SumShip, whose control source is :-
=Sum([ShipFig]}
This field also works fine, shoing the total of all ship figure fields. Another field though is called SumQualShip. The control source is :-
=Sum([QualShip]}
This doesn't work :-( When I preview the report, a dialog box asks for a parameter value for "ShipFig". If I leave it blank the area where SumQualShip should appear is blank, if I put a value in I get an SQL error.
What I want , obviously, is the total of "ShipFig" for all records where "Qual" is Y, which should also be the total of "QualShip".
All relevant fields, by the way, are formatted as General Numbers with zero decimal places.
What am I doing wrong, please ?
I have a textbox in the body of my report called "QualShip". The control source is :-
=IIf([Qual]="Y",([ShipFig]),0)
This works fine. If the trip is within tolerance the value of [ShipFig] appears in [QualShipFig], otherwise it shows zero. So far so good. But... in the report footer I have a textbox called SumShip, whose control source is :-
=Sum([ShipFig]}
This field also works fine, shoing the total of all ship figure fields. Another field though is called SumQualShip. The control source is :-
=Sum([QualShip]}
This doesn't work :-( When I preview the report, a dialog box asks for a parameter value for "ShipFig". If I leave it blank the area where SumQualShip should appear is blank, if I put a value in I get an SQL error.
What I want , obviously, is the total of "ShipFig" for all records where "Qual" is Y, which should also be the total of "QualShip".
All relevant fields, by the way, are formatted as General Numbers with zero decimal places.
What am I doing wrong, please ?