Access Replace Function in Update Query - Maintain Number FormattingHow can I use mySQL replace() to replace strings in multiple records?Subtracting in SQL with update query creates long decimalUpdate Query AccessUPDATE and REPLACE part of a stringReplacing Part of a String in Access Query - Wildcard CharactersHow to order (sort) formatted numbers in an Access Union Query (SQL)Oracle Update Query issue with Replace functionMS Access Update Query Truncates Text“Query too Complex”: MS Access Function to Replace text in Query (Nested Replace())How to maintain formatting for numbers in multi-value combo box?
Is there anything in the universe that cannot be compressed?
Why do motor drives have multiple bus capacitors of small value capacitance instead of a single bus capacitor of large value?
Where does MyAnimeList get their data from?
Received email from ISP saying one of my devices has malware
'spazieren' - walking in a silly and affected manner?
Which is the correct version of Mussorgsky's Pictures at an Exhibition?
Are spot colors limited and why CMYK mix is not treated same as spot color mix?
Why doesn't Starship have four landing legs?
What is the practical impact of using System.Random which is not cryptographically random?
Necessity of tenure for lifetime academic research
Four day weekend?
Resources to learn about firearms?
Where should I draw the line on follow up questions from previous employer
Why haven't the British protested Brexit as ardently like Hong Kongers protest?
Why does the U.S. military maintain their own weather satellites?
What was Captain Marvel supposed to do once she reached her destination?
Cheap oscilloscope showing 16 MHz square wave
How can I store milk for long periods of time?
What is the chance of getting a Red Cabbage in year 1?
My colleague treats me like he's my boss, yet we're on the same level
Break down the phrase "shitsurei shinakereba naranaindesu"
Who declared the Last Alliance to be the "last" and why?
What's the origin of the concept of alternate dimensions/realities?
Why do IR remotes influence AM radios?
Access Replace Function in Update Query - Maintain Number Formatting
How can I use mySQL replace() to replace strings in multiple records?Subtracting in SQL with update query creates long decimalUpdate Query AccessUPDATE and REPLACE part of a stringReplacing Part of a String in Access Query - Wildcard CharactersHow to order (sort) formatted numbers in an Access Union Query (SQL)Oracle Update Query issue with Replace functionMS Access Update Query Truncates Text“Query too Complex”: MS Access Function to Replace text in Query (Nested Replace())How to maintain formatting for numbers in multi-value combo box?
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;
I'm running an update query... using the replace function to update a placeholder in a memo field... with a value from a query.
When I run the query, the number that is replaced loses it's formatting. IE... it will update to 1000000, instead of 1,000,000.
Any clue how to do this properly, to maintain the formatting of the number?
ms-access replace
asked Mar 27 at 23:37
Damion RutherfordDamion Rutherford
31 bronze badge
add a comment |
I'm running an update query... using the replace function to update a placeholder in a memo field... with a value from a query.
When I run the query, the number that is replaced loses it's formatting. IE... it will update to 1000000, instead of 1,000,000.
Any clue how to do this properly, to maintain the formatting of the number?
ms-access replace
asked Mar 27 at 23:37
Damion RutherfordDamion Rutherford
31 bronze badge
1
Welcome to SO! Please take the tour and read How to Ask , then improve your question (e.g show query).
– ComputerVersteher
Mar 27 at 23:43
1
Use Format() function. Edit question to show query if you need more specific help.
– June7
Mar 28 at 1:36
add a comment |
I'm running an update query... using the replace function to update a placeholder in a memo field... with a value from a query.
When I run the query, the number that is replaced loses it's formatting. IE... it will update to 1000000, instead of 1,000,000.
Any clue how to do this properly, to maintain the formatting of the number?
ms-access replace
asked Mar 27 at 23:37
Damion RutherfordDamion Rutherford
31 bronze badge
I'm running an update query... using the replace function to update a placeholder in a memo field... with a value from a query.
When I run the query, the number that is replaced loses it's formatting. IE... it will update to 1000000, instead of 1,000,000.
Any clue how to do this properly, to maintain the formatting of the number?
ms-access replace
ms-access replace
asked Mar 27 at 23:37
Damion RutherfordDamion Rutherford
31 bronze badge
asked Mar 27 at 23:37
Damion RutherfordDamion Rutherford
31 bronze badge
asked Mar 27 at 23:37
Damion RutherfordDamion Rutherford
31 bronze badge
asked Mar 27 at 23:37
Damion RutherfordDamion Rutherford
31 bronze badge
asked Mar 27 at 23:37
Damion RutherfordDamion Rutherford
31 bronze badge
31 bronze badge
1
Welcome to SO! Please take the tour and read How to Ask , then improve your question (e.g show query).
– ComputerVersteher
Mar 27 at 23:43
1
Use Format() function. Edit question to show query if you need more specific help.
– June7
Mar 28 at 1:36
add a comment |
1
Welcome to SO! Please take the tour and read How to Ask , then improve your question (e.g show query).
– ComputerVersteher
Mar 27 at 23:43
1
Use Format() function. Edit question to show query if you need more specific help.
– June7
Mar 28 at 1:36
1
1
Welcome to SO! Please take the tour and read How to Ask , then improve your question (e.g show query).
– ComputerVersteher
Mar 27 at 23:43
Welcome to SO! Please take the tour and read How to Ask , then improve your question (e.g show query).
– ComputerVersteher
Mar 27 at 23:43
1
1
Use Format() function. Edit question to show query if you need more specific help.
– June7
Mar 28 at 1:36
Use Format() function. Edit question to show query if you need more specific help.
– June7
Mar 28 at 1:36
add a comment |
1 Answer
1
active
oldest
votes
Instead of updating to, say, NewValue, update to:
Format(NewValue, "#,##0")
answered Mar 28 at 8:43
GustavGustav
34k5 gold badges22 silver badges37 bronze badges
Perfect - thank you so much!!!
– Damion Rutherford
Mar 29 at 3:43
Great! Then please mark as answered.
– Gustav
Mar 29 at 7:21
add a comment |
Your Answer
StackExchange.ifUsing("editor", function ()
StackExchange.using("externalEditor", function ()
StackExchange.using("snippets", function ()
StackExchange.snippets.init();
);
);
, "code-snippets");
StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "1"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);
else
createEditor();
);
function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);
);
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55388091%2faccess-replace-function-in-update-query-maintain-number-formatting%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
Instead of updating to, say, NewValue, update to:
Format(NewValue, "#,##0")
answered Mar 28 at 8:43
GustavGustav
34k5 gold badges22 silver badges37 bronze badges
Perfect - thank you so much!!!
– Damion Rutherford
Mar 29 at 3:43
Great! Then please mark as answered.
– Gustav
Mar 29 at 7:21
add a comment |
Instead of updating to, say, NewValue, update to:
Format(NewValue, "#,##0")
answered Mar 28 at 8:43
GustavGustav
34k5 gold badges22 silver badges37 bronze badges
Perfect - thank you so much!!!
– Damion Rutherford
Mar 29 at 3:43
Great! Then please mark as answered.
– Gustav
Mar 29 at 7:21
add a comment |
Instead of updating to, say, NewValue, update to:
Format(NewValue, "#,##0")
answered Mar 28 at 8:43
GustavGustav
34k5 gold badges22 silver badges37 bronze badges
Instead of updating to, say, NewValue, update to:
Format(NewValue, "#,##0")
answered Mar 28 at 8:43
GustavGustav
34k5 gold badges22 silver badges37 bronze badges
answered Mar 28 at 8:43
GustavGustav
34k5 gold badges22 silver badges37 bronze badges
answered Mar 28 at 8:43
GustavGustav
34k5 gold badges22 silver badges37 bronze badges
answered Mar 28 at 8:43
GustavGustav
34k5 gold badges22 silver badges37 bronze badges
34k5 gold badges22 silver badges37 bronze badges
Perfect - thank you so much!!!
– Damion Rutherford
Mar 29 at 3:43
Great! Then please mark as answered.
– Gustav
Mar 29 at 7:21
add a comment |
Perfect - thank you so much!!!
– Damion Rutherford
Mar 29 at 3:43
Great! Then please mark as answered.
– Gustav
Mar 29 at 7:21
Perfect - thank you so much!!!
– Damion Rutherford
Mar 29 at 3:43
Perfect - thank you so much!!!
– Damion Rutherford
Mar 29 at 3:43
Great! Then please mark as answered.
– Gustav
Mar 29 at 7:21
Great! Then please mark as answered.
– Gustav
Mar 29 at 7:21
add a comment |
Got a question that you can’t ask on public Stack Overflow? Learn more about sharing private information with Stack Overflow for Teams.
Got a question that you can’t ask on public Stack Overflow? Learn more about sharing private information with Stack Overflow for Teams.
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55388091%2faccess-replace-function-in-update-query-maintain-number-formatting%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
1
Welcome to SO! Please take the tour and read How to Ask , then improve your question (e.g show query).
– ComputerVersteher
Mar 27 at 23:43
1
Use Format() function. Edit question to show query if you need more specific help.
– June7
Mar 28 at 1:36