Unanswered: formatting the values in % and align the text
In my query, I formatted the values in a field in % but I also need them align to the right of the column in the table. The query I created is a Make Table Query. If I do the setting in the Format property of the field in the table it will not save; therefore, I ‘ll need to create the setting(s) in my SQL statement in the query.
This is SELECT statement:
SELECT date, A, B, Format ([quan]/[total], “Percent”) AS A,.. INTO tblMonth FROM tblA INNER JOIN tblA.Date = tblB.Date;
What I need are the A and B values convert to % and also align to the right in the column of the table.
Yes, I do believe I just want have the values to view only.
Does the format(format([quan]/[total], “Percent”),"@@@@@@") align the values to the right? What is a @?
I made the change in my query now it’s giving me a blank column.
Can you tell me why it’s not working?
I would like the values in % and then align to the right of the column.
Really sorry, I wrote wrong the sequence. Correct is:
..., format(format([quan]/[total], "0%"),"@@@@@@") as A, ...
The @ means a blank space. With the line above, you will get a string with 6 caracters align to right. First, format transform the number in percent. After, the second format transform percent in string.