Free Lessons
Courses
Seminars
TechHelp
Fast Tips
Templates
Topic Index
Forum
ABCD
 
Home   Courses   TechHelp   Help   Contact   Merch   Join   Order   Logon   Forums   
 
Back to Access Forum    Comments List
Upload Images   @Reply   Bookmark    Link   Email   Next Unseen 
Thousandths Place Comma
Lee Shastid 
    
2 days ago
I have a field that has the total rounds for it. =sum([TotalRounds]) and it shows the value amount correctly. Like 3742 how do i get the comma for the thousandths place like 3,742?
Kevin Robertson  @Reply  
          
2 days ago
Use the Format function.

=Format(Sum([TotalRounds]),"#,##0")
Lee Shastid OP  @Reply  
    
2 days ago
Thank you.....I was leaving the format out...I appreciate it
Thomas Gonder  @Reply  
      
29 hours ago
Or if it's a text box in a form or report you should be able to format it as Standard with 0 decimal places.
Lee Shastid OP  @Reply  
    
28 hours ago
Thomas can you explain how you’re talking about. See if I am familiar with that way. Yes it is a text box on a form.
Thomas Gonder  @Reply  
      
24 hours ago

Thomas Gonder  @Reply  
      
24 hours ago

Lee Shastid OP  @Reply  
    
24 hours ago
Thomas thank you very much. I really over complicated this one. I forgot all about that option. Thank you very much.
Richard Rost  @Reply  
           
17 hours ago
Thomas I want that royalty check. :)
Thomas Gonder  @Reply  
      
16 hours ago
Richard Write a book as popular as any after the first one in the Harry Potter series. Be richer than a king!
Now I wonder, if I had of dedicated as much time to a few books as I have to thousands of programs...?
My dad used to tell tall tales at the dinner table of the "Little Red Pill Taker" (he was magical too, because of the red pills) that had us hanging on the edges of our seats. What if?
Thomas Gonder  @Reply  
      
15 hours ago
How did Aloysius get the magical red pills you ask? By saving and befriending the magical King of the Frogs, Titus, from the dreaded Wilkies. The same Frog King that leprechauns are always trying to steal gold from.

Then there was my son's maternal grandfather that sent lengthy letters about the "Adventures of Alfonse, the traveling alligator". Alfonse wasn't content to just lie around in South Carolina swamps. He longed, and did, travel the world. Complete with images of Alfonse in a Carolina straw hat, tie and Bermuda shorts toting his suitcase in Paris.

I'll bet some AI program can whip those stories up in a few minutes. $Millions will be mine--Bahahahaha!
Richard Rost  @Reply  
           
7 hours ago
I did write a book. It sold tens of copies. :)

But, it wasn't my fault that the publisher was literally the last one that year to get their Excel book out.
Thomas Gonder  @Reply  
      
5 hours ago
Richard Don't feel bad. I see many of these authors pouring their hearts into their book. Reading them must be something like going to an Al-Anon meeting. Then I see that they get deferred 23 cents in royalties for a quarter worth of sales.
I hope AI can do me better than that for Alfonse.
Richard Rost  @Reply  
           
5 hours ago
Thomas Yeah, I think they gave me an advance of a couple thousand dollars, which sounded nice until I realized how many months of work went into writing the book. This was around 2009, before AI was even a thing. The advance was nowhere near enough to compensate for the effort, but I was grateful for the opportunity.

For a few years afterward, they sent royalty statements showing how the book was selling. You have to earn back the advance through royalties before you see another dime, and mine never did. It wasn't a huge advance, but still. I can at least say I'm a published author now, even if my specialty is Access and the book was about Excel.

An agent actually found me through my YouTube videos and asked if I wanted to write a book. I thought, "Yeah, great, awesome." That was before I understood how much work a book really is. Videos are so much easier.

As for AI, it can definitely help with organizing rough notes and turning a stream-of-consciousness dictation into something coherent. But it still has a certain flavor to it. Once you recognize it, AI-generated writing often feels a little too polished, generic, and stale. It lacks that human spark. I'm sure it will improve, but for now that's the part AI can't really duplicate.
Add a Reply Upload an Image
Next Unseen

 
New Feature: Comment Live View
 
 

The following is a paid advertisement
Computer Learning Zone is not responsible for any content shown or offers made by these ads.
 

Learn
 
Access - index
Excel - index
Word - index
Windows - index
PowerPoint - index
Photoshop - index
Visual Basic - index
ASP - index
Seminars
More...
Customers
 
Login
My Account
My Courses
Lost Password
Memberships
Student Databases
Change Email
Info
 
Latest News
New Releases
User Forums
Topic Glossary
Tips & Tricks
Search The Site
Code Vault
Collapse Menus
Help
 
Customer Support
Web Site Tour
FAQs
TechHelp
Consulting Services
About
 
Background
Testimonials
Jobs
Affiliate Program
Richard Rost
Free Lessons
Mailing List
PCResale.NET
Order
 
Video Tutorials
Handbooks
Memberships
Learning Connection
Idiot's Guide to Excel
Volume Discounts
Payment Info
Shipping
Terms of Sale
Contact
 
Contact Info
Support Policy
Mailing Address
Phone Number
Fax Number
Course Survey
Email Richard
[email protected]
Blog RSS Feed    YouTube Channel

LinkedIn
Copyright 2026 by Computer Learning Zone, Amicron, and Richard Rost. All Rights Reserved. Current Time: 8/4/2026 5:12:04 PM. PLT: 1s