Totals Column In Query Datasheet

[Abdulkawi]

Hi,

(See Attatchment First)...

I'm trying to get the sub-form to display 'Subtotal', 'VAT' and 'Total' rows. And at the same time I want them to automatically calculate the values.

How can I do this?

The subform is being pulled from a query as a Datasheet.

Would really appreciate all the help, I've already spent days trying to figure this out but I'm completely blank!

Thanks

 

[PNGBill]

Your Continuous Sub Form Footer should allow you to have Calculated Unbound Text Box Controls to Sum the values. Others will then calculate the VAT etc.

 

[SteveSchapel]

Abdulkawi,

I agree with Bill. Use a Continuous View form rather than a datasheet. If you really like the look of a datasheet, you can format a continuous form to look almost the same if you like.

 

[Abdulkawi]

Is there no way I can get the totals to be in the subform like shown on the image on my first post.

 

[SteveSchapel]

Abdulkawi,

Yes. No problem. It is very easy to get the totals to be in the subform like shown on the image on your first post. Bill and I have both already explained this. Change the subform from a datasheeet view to a continuous forms view. Put unbound textboxes in the Footer section of the form used for the subform, with the Control Source property of these textboxes set to do the required calculations.