Summing in Datasheet

[grenee]

Good day all.

My form is a datasheet with 2 fields: "Product" and "Quantity". Obviously I can't add a calculated field in this type of form; however I would like the word " Total" to display in the "Quantity" field just under the last record. I would also like the sum of the "Quantity" field to display at the bottom of the "Quantity" field in the empty record below the last record.

I would be grateful for advise on this problem.

 

[spikepl]

Good evening.

Cliick totals-icon on the ribbon

 

[Galaxiom]

Obviously I can't add a calculated field in this type of form;.

Actually you can add a calculated control ("fields" are in tables, queries and recordsets) to a datasheet form. It is just that it isn't displayed.

Place the calculated control in the footer in Design View. Despite not being displayed in Datasheet View it can still be referred to from other objects.

For example, a control in the footer of a subform datasheet can be referred to in the ControlSource of a control on the main form where the result can be displayed.

 

[grenee]

Thanks; but I can't find the totals-Icon you are referring to.

 

[grenee]

Thanks for this useful explanation: however, I am trying to understand how to get the totals displayed in the actual datasheet. I am seeing this example in the Northwind sample database in a form "Order subform for Order details". I want to know how this is done.

 

[Gasman]

If I understand you correctly, the subform total is in the footer of that form.
That is then referred to on the main form, just below the subform.

The footer is not visible when you use the main form.

 

[grenee]

Thank.

not really; there in no calculated control. The sum of the field is directly on the bottom of the same Datasheet. Actually it is in the 2nd row below the last record

 

[Gasman]

Picture please?

Thank.

not really; there in no calculated control. The sum of the field is directly on the bottom of the same Datasheet. Actually it is in the 2nd row below the last record

 

[grenee]

Hope this helps.


Order Subform for Order Details
Product Qty Unit Price Discount Total Price Status Lamp Shade 0 $10.00 0.00% $0.00 None Table Lamp 6 $40.00 0.00% $240.00 Allocated Table Lamp 20 $40.00 0.00% $800.00 Allocated
26

$1,040.00

 

[grenee]

That was incorrect.

 

[Gasman]

It does not.

What version of Access are you using as I only have 2003.

Attached is my Order Subform

 

[grenee]

The Datasheet distorts when placed in this window. And I can't get an image import.

 

[Gasman]

I copy the screen (either Shift & PrtSc or Alt & PrtSc)
Then paste in to Paint, Save and upload that file.

 

[grenee]

I have 2010

 

[grenee]

ok I tried it as an attachment

 

[Gasman]

Ah, OK,

Later versions of Access have more features and I seem to recall 2007 allowed totals.

This should help

https://support.office.com/en-au/ar...atasheet-8f1f89c4-7f86-4113-a836-291ac3ea446e

taken from

https://www.google.co.uk/search?q=a....57j0l2j62l3.12681j0&sourceid=chrome&ie=UTF-8

And this is on this site.

http://www.access-programmers.co.uk/forums/showthread.php?t=228046

I am unable to help further as my version is way too old.

HTH