SharkFin85 Posted May 8, 2007 Share Posted May 8, 2007 If I put the sum(Field01) function in a calculation field the result is.... Field01 of 1st Record + Field01 of 2nd Record + Field01 of N Record. My problem is that i don't want to sum all the records, Link to comment Share on other sites More sharing options...
mr_vodka Posted May 8, 2007 Share Posted May 8, 2007 A summary field may be what you need but I am afraid that you have not supplied enough information as to what are you trying to achieve. Link to comment Share on other sites More sharing options...
comment Posted May 8, 2007 Share Posted May 8, 2007 Your premise is incorrect. It would be correct if you were referencing a RELATED field - then the result would be: Field01 of 1st Related Record + Field01 of 2nd Related Record + ... + Field01 of Nth Related Record Now, what DO you want to sum? Link to comment Share on other sites More sharing options...
SharkFin85 Posted May 8, 2007 Author Share Posted May 8, 2007 I have 2 tables that are related with a "year" field . One table is the "invoices" and the other is the "MonthBalance). In the second table i have 12 fields (TotBalane Jan,TotBalane Feb,TotBalane Mar.....TotBalane Dec). So I want to sum the total balance of all the invoices of 2006(example) but i want the field "Totalbalance Jan" to appear the total balance of the invoices that where created in Jan 2006. I hope now understand my problem : sorry for my English Link to comment Share on other sites More sharing options...
comment Posted May 8, 2007 Share Posted May 8, 2007 The way you have it now, you would need 12 separate relationships between the tables. A simpler solution would be to have 12 RECORDS in the MonthBalance table. Even simpler would be to produce a report in Invoices, sub-summarized by month. Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 6189 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