Help With Calculation Field Please?

[Jared867]

Hello,

Im not sure what you would call this BUT...

I have two fields in the database I am trying to design that I do NOT want associated with any record.

What I have is A summary field that adds up the total of the fields call "Spent" and then another summer that adds up the total of the fields called "Earned" Then I have an another field that is a calculation field called "Total Profit" that finds the difference between Spent and Earned. That all works well. However, occassionally I need to adjust "Spent" and "Earned" from another source so I am trying to put in 2 more fields one is called "Adjust Spent from Book" and another is called "Adjust Earned from Book" I will plug numbers in here and they will getadded t o Earned and Spent. However, when I create these fields, they become associated with a record. I dont want that. I want them to be associated with no records but I dont know how to do this. I hope I am making sense in my explanation. Please help?

Thank you, Jared

[Ugo DI LUCA]

Hi,

These fields would necessarilly be associated to something (i.e. a Year ).

Following this example, I'd handle this with a Table Year and an id associated to this other table, for each records. So that the adjustments could be made on this related Table.

We surely need a little more information about what exactly categorizes the foundset/subset of records you're listing.

[comment]

A global field is not associated with any specific record. However, I agree with Ugo that most likely the values SHOULD be associated with . For example, if these are earnings/expenses that belong to a project, then there should be a parent project record, and these values would be stored there.