How to set a number format in Union Query

[Sandhya1988]

Hello friends,
How to set a serial number format with text in union query?

I was tried to some of number formats in union query so some formats is working good some of formats is not working in union query but all number formats are working in tables, forms & reports also.

I have merged 3 query’s in union query. So they have 3 different number formats like a serial number start with (A0001, B0001, R0001) this format is working good on union query but some formats is not working like as (S0001, SR0001, SR-A0001, SI-A0001) this formats is not working and mainly start with “ S “ letter is not working on union query. I have attached the screenshot with explanation so can anyone replay how to set number format in union query???

Mostly i need this number formats on union query (S0001, SR0001, SR-A0001, SI-A0001)


Thanks,
Sandhya.

[Rabbit]

S is a reserved character in the format string. You need to escape it by using a backslash.

[Sandhya1988]

Thank you so much dear its working perfectly. I just used backslash