Forum Discussion
QuickBaseCoachD
7 years agoQrew Captain
so why not load the Banner table with the sorted names in addition to the clean name.
ie if you wanted Woolworths to sort first, you would load this new field in that table as " Woolworths" ( you would not actually load the quotes, but I'm showing that you would load with a leading space as spaces sort first). The field would be called [Banner(Sorted])
Then just look that up to any table where you need a sorted banner for summary reports.
ie if you wanted Woolworths to sort first, you would load this new field in that table as " Woolworths" ( you would not actually load the quotes, but I'm showing that you would load with a leading space as spaces sort first). The field would be called [Banner(Sorted])
Then just look that up to any table where you need a sorted banner for summary reports.