Prev: Change the date format and now no calendar pop-up appears
Next: dlookup with if
From: 136899587 on 22 Mar 2010 21:49


"alex" <user(a)msgroups.net/> д����Ϣ
news:#IiXAWhyKHA.5288(a)TK2MSFTNGP05.phx.gbl...
> Beginner here!
>
> i have for example this column in Access
> '439965'
> '23112'
> and I want to put a comma after the first 2 digits
> and look like this. I dont mind creating a new column
> '43,9965'
> '23,112'
>
>
> ---
> frmsrcurl: http://msgroups.net/microsoft.public.access

From: 136899587 on 22 Mar 2010 21:49


"alex" <user(a)msgroups.net/> д����Ϣ
news:#IiXAWhyKHA.5288(a)TK2MSFTNGP05.phx.gbl...
> Beginner here!
>
> i have for example this column in Access
> '439965'
> '23112'
> and I want to put a comma after the first 2 digits
> and look like this. I dont mind creating a new column
> '43,9965'
> '23,112'
>
>
> ---
> frmsrcurl: http://msgroups.net/microsoft.public.access

From: 136899587 on 22 Mar 2010 21:49


"Jeff Boyce" <nonsense(a)nonsense.com> д����Ϣ
news:OJ#F9jhyKHA.2644(a)TK2MSFTNGP04.phx.gbl...
> Alex
>
> Bear in mind that the number 439965 needs its comma after 3 digits, where
> 23112 needs a comma after 2 ...
>
> Now, if those aren't really NUMBERS (things you do math on), but just
> characters that happen to be digits, that's a different matter.
>
> You can check Access HELP for the use of the Left() and Mid() functions to
> grab the first two characters. If you use a query, you can concatenate
> the first two, a comma, and the remainder into a new field.
>
> Good luck!
>
> Regards
>
> Jeff Boyce
> Microsoft Access MVP
>
> --
> Disclaimer: This author may have received products and services mentioned
> in this post. Mention and/or description of a product or service herein
> does not constitute endorsement thereof.
>
> Any code or pseudocode included in this post is offered "as is", with no
> guarantee as to suitability.
>
> You can thank the FTC of the USA for making this disclaimer
> possible/necessary.
>
> "alex" <user(a)msgroups.net/> wrote in message
> news:%23IiXAWhyKHA.5288(a)TK2MSFTNGP05.phx.gbl...
>> Beginner here!
>>
>> i have for example this column in Access
>> '439965'
>> '23112'
>> and I want to put a comma after the first 2 digits
>> and look like this. I dont mind creating a new column
>> '43,9965'
>> '23,112'
>>
>>
>> ---
>> frmsrcurl: http://msgroups.net/microsoft.public.access
>
>
First  |  Prev  | 
Pages: 1 2
Prev: Change the date format and now no calendar pop-up appears
Next: dlookup with if