Dependent Function

1 reply [Last post]
BaldEagle
Offline
Last seen: 4 weeks 3 days ago
Title:
Joined: 21 Apr 2016
Posts: 3
Hi All,

I’m wondering if it is at all possible to create field in my database that serves as a function.

I have two fields, each with a number populating in the records. Is it possible to have another field that does nothing but automatically report the percentage one is of the other – like we can do in Calc?

Any help would be appreciated.

Thanks.

Ratskinger
Offline
Last seen: 4 days 18 hours ago
Title: ★★★★
Joined: 23 Feb 2016
Posts: 91
DB Fields
There is no calculated field type. In fact, when designing DB’s, fields calculated from other fields are typically frowned upon for various reasons. You can, however, create a field in a Query which is a result of a calculation using other fields. This calculation is only valid if the original values remain unchanged. Once the original values change, the query must be re-run to reflect the new result.

Comment viewing options

Select your preferred way to display the comments and click "Save settings" to activate your changes.