Here’s a tuff one:
I have this table :
and i would like to establish 3 or 4 levels of each cost center#, but, for each company and each year, as long as the TipoConta is like “M”, like this pic
I believe there’s a better way than merge queries 3 or 4 times on the same one…kinda messy i think.
In those pics you can’t see a column for the length of Cost Center#, but it’s there, just in case you need it.
Do you guys have a better idea?
Thanks and best regards to all of you