SherryLynn
Technical User
On my main form the user selects an item from a list.
On my report I need to calculate how many times the user selected one of the options. For this I have been using the DCount function. However, in a couple of categories on the report, I need to calculate how many times the user selects 2 different items from the list. A total count of these.
Eg. On the form:
User selects from Legal Status field - Permanent Guardianship on one record. On the next record he chooses Temporary Guardianship.
In the report:
The category Legal Status adds both of these status for a total count. Say there were 3 selections for Permanent and 2 for Temporary, then I would want to see 5 for that total.
Can I achieve this using the DCount function in a calculated control? Is there a way to add these fields together? Please help.
Thanks, Sherry
On my report I need to calculate how many times the user selected one of the options. For this I have been using the DCount function. However, in a couple of categories on the report, I need to calculate how many times the user selects 2 different items from the list. A total count of these.
Eg. On the form:
User selects from Legal Status field - Permanent Guardianship on one record. On the next record he chooses Temporary Guardianship.
In the report:
The category Legal Status adds both of these status for a total count. Say there were 3 selections for Permanent and 2 for Temporary, then I would want to see 5 for that total.
Can I achieve this using the DCount function in a calculated control? Is there a way to add these fields together? Please help.
Thanks, Sherry
