input a comma after 2 digits
in [General]
|
From: alex on 22 Mar 2010 19:15 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: Jeff Boyce on 22 Mar 2010 19:39 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
From: Jeff Boyce on 22 Mar 2010 19:41 A secondary thought -- you really don't need (or want) to store two copies of (essentially) the same value. What you describe sounds more like an issue of formatting (what it looks like on display) than what you actually store in the database. 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
From: Alex on 22 Mar 2010 19:47 these are actually coordinates so i just need to put put a "." or a "," after the first two digits, no mater how many numbers i have after. But the 'left' function i think will do the trick. thank you! --- frmsrcurl: http://msgroups.net/microsoft.public.access/input-a-comma-after-2-digits
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
|
Next
|
Last
Pages: 1 2 Prev: Change the date format and now no calendar pop-up appears Next: dlookup with if |