Results 1 to 2 of 2
  1. #1
    Scotchegg is offline Novice
    Windows 10 Access 2016
    Join Date
    Sep 2022
    Posts
    3

    Total subdatasheet

    I need to total up the total column on a subform datasheet but it only comes up with the options none or count.
    Click image for larger version. 

Name:	Fixings Subform Datasheet Design View.PNG 
Views:	16 
Size:	18.6 KB 
ID:	48768Click image for larger version. 

Name:	Fixings Subform Datasheet View with totals options.png 
Views:	16 
Size:	34.7 KB 
ID:	48769
    Fixings Sub form Datasheet view with totals options attached, i have hidden some columns that i don't want showing.



    Fixings Sub form Datasheet Design view shows the total column with the formula, just a guess but is it not totalling because this is a formula?

    If so I have read about adding a total column to the footer ad referencing to that on the detail part of the sub form but i have tried and failed any help would be much appreciated.
    Attached Thumbnails Attached Thumbnails Fixings Subform Datasheet View.PNG  

  2. #2
    Join Date
    May 2018
    Location
    Living in Scotland UK
    Posts
    1,557
    Hi
    Base your Fixings Subform on a query and do all of the Calculations in the query and NOT on the Form.
    You can PM me if you need further help.
    Good Reading https://docs.microsoft.com/en-gb/off...on-description

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Subdatasheet Issue
    By rmoore in forum Access
    Replies: 4
    Last Post: 06-16-2021, 03:05 AM
  2. Add new entry from subdatasheet
    By Faeyren in forum Access
    Replies: 3
    Last Post: 02-23-2017, 02:08 PM
  3. 2x SubDataSheet in web database
    By Cazca in forum Access
    Replies: 1
    Last Post: 12-06-2015, 10:52 AM
  4. Exporting subdatasheet
    By DHIGHTO in forum Import/Export Data
    Replies: 3
    Last Post: 01-28-2015, 12:53 PM
  5. Problem with subdatasheet
    By bryanno in forum Access
    Replies: 1
    Last Post: 03-13-2010, 08:23 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums