Newbie Help!

[nikthomas]

I hope you can help. I have read for many hours and tried examples to help me resolve my subtotal error on a form/subform, but alas no joy.

This forum has been an exellent resource and the answers with the posts have resolved many problems I have encountered.

But the time has come to ask a question!

On a simple subform, I have the Line Total all working fine and dandy. But, for the life of me I cannot get my Total text box in footer to work?

My Line Total calc is

=([Quantity]*[SellPrice])*((1-[Discount])*100)/100

And on the posts I have learnt that I must have Sum of this calc in my total box, but I either get 0 or #Error.

Can anyone please help?

 

[AlienRay]

Is there a chance any of these fields will ever be null? If so, you might want to use Nz to account for such occasions.

 

[quest4]

The Nz idea is a good on and should be tried first and if it works, ignore me. If it does not work, then look at a few things. This is a main for with a subform, is that correct? The data, which you are trying to total is in the subform, is that correct? You are trying to put the total of that data on the main form, is that correct. If the last statement is true, then we probably have some syntax problems. Just a little food for thought. hth.

 

[nikthomas]

Yes it is possible that the values could be Null.

I have tried with nz, I do now get the line value of the selected record, but I need it to Sum all the Line Totals of all records in the Datasheet!

Any Ideas

 

[quest4]

This was posted somewhere else and somehow got over here. Sorry.

 

[Oldsoftboss]

In a text box in the sub form footer set the control source as:

= sum(.......put the line calc in here......)

Dave