SOLVED

Total row in datasheet view on a form won't work.

%3CLINGO-SUB%20id%3D%22lingo-sub-2885649%22%20slang%3D%22en-US%22%3ETotal%20row%20in%20datasheet%20view%20on%20a%20form%20won't%20work.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2885649%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22SertanCPH_0-1635247377305.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F320006iD3D8B651472A6725%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22SertanCPH_0-1635247377305.png%22%20alt%3D%22SertanCPH_0-1635247377305.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EI%20would%20like%20to%20have%20a%20total%20row%20in%20this%20form.%20The%20form%20is%20in%20Datasheet%20view.%20That's%20why%20all%20the%20subforms%20are%20displayed%20as%20sub-datasheets%2C%20but%20they%20are%20actually%20nested%20sub%20forms%20in%20the%20datasheet%20view.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhat%20do%20you%20think%20is%20the%20problem%20here%3F%20The%20lookup%20field%20'Number'%20is%20where%20the%20user%20enters%20the%20part%20number%2C%20and%20the%20%5BDescription%5D%20and%20%5BPrice%5D%20fields%20are%20only%20available%20in%20the%20form%2C%20and%20data%20source%20is%20the%20lookup%20columns%20from%20%5BNumber%5D%20field.%20Is%20that%20the%20reason%20the%20sum%20doesn't%20show%20up%3F%20How%20can%20I%20fix%20this%20problem%3F%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2885649%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAccess%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2886113%22%20slang%3D%22en-US%22%3ERe%3A%20Total%20row%20in%20datasheet%20view%20on%20a%20form%20won't%20work.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2886113%22%20slang%3D%22en-US%22%3EMy%20guess%20is%20that%20you%20are%20right%20in%20pointing%20to%20the%20fact%20that%20this%20calculation%20can't%20handle%20the%202nd%20and%20third%20columns%20of%20the%20combo%20box%20in%20the%20summation.%20You%20can%20fix%20it%2C%20probably%2C%20by%20modifying%20the%20query%20which%20provides%20records%20to%20the%20form%20so%20that%20the%20required%20fields%20are%20available%20instead.%3C%2FLINGO-BODY%3E
Occasional Contributor

SertanCPH_0-1635247377305.png

I would like to have a total row in this form. The form is in Datasheet view. That's why all the subforms are displayed as sub-datasheets, but they are actually nested sub forms in the datasheet view. 

 

What do you think is the problem here? The lookup field 'Number' is where the user enters the part number, and the [Description] and [Price] fields are only available in the form, and data source is the lookup columns from [Number] field. Is that the reason the sum doesn't show up? How can I fix this problem? 

2 Replies
best response confirmed by SertanCPH (Occasional Contributor)
Solution
My guess is that you are right in pointing to the fact that this calculation can't handle the 2nd and third columns of the combo box in the summation. You can fix it, probably, by modifying the query which provides records to the form so that the required fields are available instead.

@George Hepworth 

Thank you. I have fixed it by creating a query with the needed fields.