There are a few hundred properties, each with their own water treatment system. They are tracking the flow (amount of gallons) through each treatment system.
My current lne of thinking is a summary field to each treatment system, which combined texts all the info i need, then i re-split it apart and use a combination of Part + If statements looking at each part. I think this will work but is a ludicrously long formula, though a repeating formula. Maybe 50 lines so not the worst. I cant think of another way. It's too bad because this is exactly what a query would be perfect for.
------------------------------
Michael Tamoush
------------------------------
