Merge and Sum Functions
I am looking for a way in filemaker database for it to look at multiple fields and if they match sum and merge the fields. I want it to merge the records if both Cards & Address field are the same. So it will use both Address and Cards as factors of merge & Sum. Example of the Table before and after the merge & Sum are attached. If you see the only one it merged would be the one with the Same Address and Same Card and then it merge and sum the ones that meet that criteria. Is this possible?