D DBFIN Registered User. Local time Today, 15:43 Joined May 10, 2007 Messages 205 Feb 10, 2016 #1 I'm trying to add a field total by clicking on the field and then selecting the sum function while in layout view. The sum function is grayed out, so I am not able to add a sum.
I'm trying to add a field total by clicking on the field and then selecting the sum function while in layout view. The sum function is grayed out, so I am not able to add a sum.
C cyanidem Nieóhfytny jaszczomp Local time Today, 20:43 Joined Nov 30, 2015 Messages 106 Feb 10, 2016 #2 I think you need to be in design view, not layout view to do it.
D DBFIN Registered User. Local time Today, 15:43 Joined May 10, 2007 Messages 205 Feb 10, 2016 #3 I researched both the layout and design view methods, the sum option is gray either way.
D DBFIN Registered User. Local time Today, 15:43 Joined May 10, 2007 Messages 205 Feb 10, 2016 #4 I think I may have discovered the issue, the field is formated in text, can't sum text.
C cyanidem Nieóhfytny jaszczomp Local time Today, 20:43 Joined Nov 30, 2015 Messages 106 Feb 10, 2016 #5 Ah yes, that too, but I thought it was obvious.
D DBFIN Registered User. Local time Today, 15:43 Joined May 10, 2007 Messages 205 Feb 10, 2016 #6 Thanks again !!