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

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

×
×
  • Create New...

Important Information

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