J
JackieV
I cannot figure out (I spent hours agonizing over this) how to
display/calculated field on a form based on criteria.
I have a table field, 'rotWeeks', that I would like to display only if
another field value, 'rotCancel', is False.
In addtion, I would like to Sum 'rotWeeks' based on the same criteria.
For example, if there were 3 records with 'rotWeeks' values of 4, 2,
and 4 and the first one had a 'rotCancel' value of 'True' then the Sum
of 'rotWeeks' should be 6.
here is the basic table structure:
rotID <pk>
msID <fk>
rotWeeks - numerical
rotCancel - T/F
The sum of 'rotWeeks' would be by 'msID'
Any help would be great!
Thanks in advance!
JV
display/calculated field on a form based on criteria.
I have a table field, 'rotWeeks', that I would like to display only if
another field value, 'rotCancel', is False.
In addtion, I would like to Sum 'rotWeeks' based on the same criteria.
For example, if there were 3 records with 'rotWeeks' values of 4, 2,
and 4 and the first one had a 'rotCancel' value of 'True' then the Sum
of 'rotWeeks' should be 6.
here is the basic table structure:
rotID <pk>
msID <fk>
rotWeeks - numerical
rotCancel - T/F
The sum of 'rotWeeks' would be by 'msID'
Any help would be great!
Thanks in advance!
JV