Disappearing data in calculated field

[Timberwolf]

I have a form that contains some fields that are summed in a total field. The first three fields (FirstTierHours, SecondTierHours, and MonitorHours) are added right in the query to create a Subtotal field. That works beautifully.

Now I've added a subform that shows hours that other staff members have logged for consulting on a client's file. That subform contains a ConsultTotal calculated field in the report footer that adds the hours for the client. This also works beautifully. (For reference, this subform is located on page three of my main form.)

Now for the funky part. On page two of my main form are the fields and totals:

FirstTierHours = 6.50
SecondTierHours = 7.50
MonitorHours = 1.00
Subtotal (invisible field) = 15.00
ConsultHours = 1.00 (from subform)
Total = 16.00
(The Total field calculation is =[Subtotal]+[ConsultHours].)

And it works beautifully. Except for records for which there are no Consulting hours!!! When you get to a record for a client for whom there are no Consulting hours, the (correct) Total is visible for a split second, but then it disappears! For clients for whom there are Consulting hours, the (correct) Totals are visible, and they stay visible. What the heck?!

Can anyone help me? Thanks so much!

Ann

 

[kbreiss]

not for sure if this would work....but how about defaulting your "ConsultHours" to '0'? Hopefully would perform the correct calculation with fields both being filled.

HTH,
Kacy
________
Handjob vid