worldcrafter
New member
- Local time
- Today, 09:39
- Joined
- Feb 9, 2004
- Messages
- 7
I have a memo field in my report that I want to calculate a total for. Say I have 10 records total out of my database for which this memo field actually is filled up (all other memos in other records in the db are left blank). I want my report to calculate and show a total for the number of records that actually have this memo field filled out. So my report would have a text box which says:
(Label)this memo was filled out: (Textbox) 10
I tried calculating a total with the following code:
=Abs(Sum([memofield]))
but I get an pop-up error box that says "access cannot use memos in aggregate arguments", or something to that extent.
So how can I calculate a total for the number of people that filled out this memo field? I was thinking of just making a check box that corresponds to the memo field, and if anyone fills out the memofield, they will manually have to click the check box as well. But that may mean more work and more errors for me, since some check box fields may not be checked off when the memofield is filled out (e.g. someone forgets to manually check the checkbox field).
Hopefully I'm clear as to what I'm asking for, which again is a total count for the number of people who actually filled out the memofield in my db. Am I being redundant enough?
(Label)this memo was filled out: (Textbox) 10
I tried calculating a total with the following code:
=Abs(Sum([memofield]))
but I get an pop-up error box that says "access cannot use memos in aggregate arguments", or something to that extent.
So how can I calculate a total for the number of people that filled out this memo field? I was thinking of just making a check box that corresponds to the memo field, and if anyone fills out the memofield, they will manually have to click the check box as well. But that may mean more work and more errors for me, since some check box fields may not be checked off when the memofield is filled out (e.g. someone forgets to manually check the checkbox field).
Hopefully I'm clear as to what I'm asking for, which again is a total count for the number of people who actually filled out the memofield in my db. Am I being redundant enough?
