sdutton Posted April 16, 2011 Share Posted April 16, 2011 I've created a simple database to inventory our home belongings for our move. The fields are Item, Description, and Value. I'd like to create a calculated field for the "Total Value", adding together the individual values of all the records. How do I do that? Link to comment Share on other sites More sharing options...
bcooney Posted April 17, 2011 Share Posted April 17, 2011 Create a summary field that equals Total of Value. Link to comment Share on other sites More sharing options...
sdutton Posted April 18, 2011 Author Share Posted April 18, 2011 Create a summary field that equals Total of Value. I created a calculation: Sum ( Value ) , but it only shows the total value for a selected individual record, not the total value of all the records. Link to comment Share on other sites More sharing options...
Vaughan Posted April 18, 2011 Share Posted April 18, 2011 Create a *summary* field, not a calculation field. Link to comment Share on other sites More sharing options...
sdutton Posted April 19, 2011 Author Share Posted April 19, 2011 Create a *summary* field, not a calculation field. Thank you . . . it works! Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 4753 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now