Aussie John Posted April 30, 2004 Share Posted April 30, 2004 Hi I have a summary field which is a total of a calculation field. The summary field only updates after closing the file and reopening it. I tried changing the storage options but I get a message telling me I cant change the storage options as the calcultion is based on a related field ( which it is). any ideas? thanks Link to comment Share on other sites More sharing options...
ktstem Posted April 30, 2004 Share Posted April 30, 2004 Try using a calc instead of a summary Sum(DB Name::Your Field) Link to comment Share on other sites More sharing options...
Aussie John Posted May 2, 2004 Author Share Posted May 2, 2004 Thanks for that- but I dont get a summary total of all the records by that method Link to comment Share on other sites More sharing options...
QuinTech Posted May 3, 2004 Share Posted May 3, 2004 You can do this through a script which sets some plain ol' number field to the value of your unusable calc field, then base your summary off the number field. Just trigger the script through a button labeled "Recalc" or something. Jerry Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 7152 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