Summary Field of a Formula
I'm a longtime QB user and seem to run up against this limitation often. I was wondering if anyone has found a good workaround. My data consists of three fields, "Date", "Division", and "Amount". I...
Forum Discussion
Thanks for the reply. I need to do further calculations with the cost data that need to summarize, so a summary report isn't going to work.
I'm not following your last comment. I have created a parent table with every possible combination of YYYY-MM-DIV, which is the unique key field in the parent table, but in order to make the relationship to the same data in the details table, I'd have to use a function to concatenate the three fields to one, which doesn't work.
I'm not following your last comment. I have created a parent table with every possible combination of YYYY-MM-DIV, which is the unique key field in the parent table, but in order to make the relationship to the same data in the details table, I'd have to use a function to concatenate the three fields to one, which doesn't work.