L
Lou
I am very new user in Access.
I am creating a database to count employee activity date. It has a main form
with a subform. In the subform I have rows with activity dates where I can
select the activity and enter the date. The columns I want to count are
column A and column B. In other words, I want a total count for column A and
column B.
In the subform footer, I created two fields one countif column A is between
the number 1 and 5; the second counta column B.
On the main form the total count for column A is -1, if I am viewing row 1
and 0 for column B. If I am view row 2 the total count is 0 for column A and
-1 for column B.
Help!
I am creating a database to count employee activity date. It has a main form
with a subform. In the subform I have rows with activity dates where I can
select the activity and enter the date. The columns I want to count are
column A and column B. In other words, I want a total count for column A and
column B.
In the subform footer, I created two fields one countif column A is between
the number 1 and 5; the second counta column B.
On the main form the total count for column A is -1, if I am viewing row 1
and 0 for column B. If I am view row 2 the total count is 0 for column A and
-1 for column B.
Help!