Hello again!
I am now trying to sum a YES/NO field using an Expression in the Totals field of the query as follows:
Abs(Sum([myfield]))
I know for a fact that the total should equal 1, but the results keep on coming back as 2.
NOTE: I have many records but of all the records, I only checked [myfield] on one record. I queried the database and grouped by my primary key to see if there was a hidden one somewhere but came up only showing that the calculations are from only the one record I checked "Yes".
Does someone have any insight to this?
Thanks so much,
Nick
I am now trying to sum a YES/NO field using an Expression in the Totals field of the query as follows:
Abs(Sum([myfield]))
I know for a fact that the total should equal 1, but the results keep on coming back as 2.
NOTE: I have many records but of all the records, I only checked [myfield] on one record. I queried the database and grouped by my primary key to see if there was a hidden one somewhere but came up only showing that the calculations are from only the one record I checked "Yes".
Does someone have any insight to this?
Thanks so much,
Nick