Format

[rizabdullah]

Hi Guys

How do I format numbers to text in SELECT query. My query is:

SELECT Qry_Cognos_Stores.el3_cmpcode, Qry_Cognos_Stores.el3_code, Qry_Cognos_Stores.el3_name, Qry_Cognos_Stores.StoreId, ("Store" & [Qry_Cognos_Stores]![StoreId] & "@mothercare.com") AS Email
FROM Qry_Cognos_Stores;


Many thanks

 

[CJ_London]

use the format function e.g.

format(mynumber,"#0.00")

format string as you require. google 'vba format function' for all the different options

However usually better to format the control in the destination form or report. google 'access control format property' to find out more - it has more flexibility for colour etc