align/justify text in calculation field
Attached is a layout for a show guide I produce. The last line on each of the wines (records) is a single calculation field that ensures the right prices are applicable to each record. As you can see some records use 5 prices and others use 2 prices.
The prices need to be laid out in such a way that the first price is justified left and the last price is justified right with any other prices to be set evenly between the two.
The question is how to either, set the field to spread the results of the calculation field or to develop the calculation to lay it out for me. I suspect the calculation field is the only way to go.
I've tried using tabs but given the number of permutations, not to mention the differing nos of characters in the prices, it isn't possible to organise the tabs.
Hope someone can help. It's one of those ones that has really stumped me and maybe I just can't see the wood for the trees?