Good morning,
I have a table that has a column where street addresses are stored. Through a series of formulas, I display that address in a report in a specific format. For example, information such as the apartment number is excluded. The formulas work perfectly. But, I want to group the formatted field so that I can identify all of the records at a each building. Unfortunately, the group is basing on the original address field, not the formatted address field, despite grouping by the formatted address field. Does anyone have any suggestions or ideas?
I have a table that has a column where street addresses are stored. Through a series of formulas, I display that address in a report in a specific format. For example, information such as the apartment number is excluded. The formulas work perfectly. But, I want to group the formatted field so that I can identify all of the records at a each building. Unfortunately, the group is basing on the original address field, not the formatted address field, despite grouping by the formatted address field. Does anyone have any suggestions or ideas?