Jump to content
Sign in to follow this  
SharkFin85

Sum in a calculation field

Recommended Posts

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,

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

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?

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

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 account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

  • Who Viewed the Topic

    1 member has viewed this topic:
    ron n 
×

Important Information

By using this site, you agree to our Terms of Use.