Text align - Access Query

[prabhu]

All,

In my table, i have datas with 6 digits and 7 digits, when i run the query, i want all the results in 7 digits, which means, for all the 6 digits datas, i would like to have one space in front of the data - How to do this in Query ?

 

[MStef]

Send a short example of your MDB, (access2000 or 2002-2003).

 

[prabhu]

I am using access - 2003.

Please find the attachements for example.

AS IS - The query with problem
TO BE - I am looking for the output like this

 

[MStef]

Look at "DemoTextAlignA2002-2003.mdb" (attachment, zip).
f1 is a TEXT field. In the query put a FORMAT on this field,
FORMAT = @@@@@@@.
Look at Query1 (Format for f1 field).
Run query and see. I think it is what you need.

 

[prabhu]

Thank you Verymuch Mstef, Its working fine in my Query.

Will it wont work with maketable? I tried its not working.