I have am M Access 2016 report in which there is a text field. I would like to calculate on that text field and do a count on that field. How do I do that?
I have am M Access 2016 report in which there is a text field. I would like to calculate on that text field and do a count on that field. How do I do that?
In which section is this text field placed on the report?
What exactly are you trying to count?
--- the text field is in the detail portion of the report ; however, I'd like to put the calculated field in the group footer of the report. The text fields comprise common phrases like "waiting for reply". I'd like to calculate how many "waiting for reply" comments I have
Follow the steps shown here: http://www.databasedev.co.uk/count_values_countiif.html
Many thanks.Follow the steps shown here: http://www.databasedev.co.uk/count_values_countiif.html
I imported the original table from an EXCEL spreadsheet. It is my preference to group against the Large Text field since the data is entered "generically" and actually serves my needs best.. For example the field contains such information as "Collected and assigned" or "Collected and Unassigned" or " no assignment required due to xxxxxx" or "assignment required due to xxxxx". These are the only entries entered in the large text field. So, I would like to group them by this field and then in the details include fields that are associated with the group like " employee name", "date initiated", "date completed". I would then like to COUNT how may of each Large Text field group there are.
I am not able to do any of this at the moment.
looks like the same thread as https://www.accessforums.net/showthread.php?t=77592