HOW CAN I MAKE MY UNION QUERY TO DISPLAY NUMBERS WITH CERTAIN FORMAT AND RIGHT ALIGNMENT?
Yesterday I asked how to FORMAT fields in union query and I got a reply from HomerBoo (Thank you very much!) wich helped me to apply the desired format to my field, BUT...
... it works fine with text fields or phone numbers, but when the field contains numbers with different sizes it threats them as TEXT and align them left.
I made a search in the forum and I found that FORMAT function really threats everything as TEXT (at least in union queries). I found solutions when the field should contain date or currency but I still don't know HOW TO MAKE BOTH THE FORMAT AND RIGHT ALIGNMENT?