Free Lessons
Courses
Seminars
TechHelp
Fast Tips
Templates
Topic Index
Forum
ABCD
 
Home   Courses   Index   Templates   Seminars   TechHelp   Forums   Help   Contact   Join   Order   Logon  
 
Home > Courses > Access > Expert > X11 > < X10 | X12 >
Back to Access Expert 11    Comments List
Upload Images   Link   Email  
Microsoft Access Expert 11
Neal Groeling 
    
5 years ago
In Lesson 3 at the 10:57 mark, is it possible to the format property for AvgSales set as currency to see it rounded? I realize if you were working with numbers that were not currency this would be confusing, but in this case...?
Richard Rost 
           
5 years ago
Sure. Just add the Round function. AvgSales: Round(Quantity * UnitPrice). If that doesn't work, you might have to feed the results from this query into a second query and do the rounding there. I'd have to test it to be sure, and it's 3am and my brain is starting to shut down. LOL. Give it a shot and let me know.
Neal Groeling OP 
    
5 years ago
Richard, thanks for the reply. I actually just went into the query and opened the properties for AvgSales, set the format to currency, and ran the query. Without adding ROUND, it turned it into a rounded currency in the results. On another note, I've noticed that in some queries when selecting a column, under properties and format, there are no choices and the dropdown does not work. Any ideas why? BTW, my brain quits at 10pm.
Richard Rost 
           
5 years ago
Be careful with JUST formatting a value as currency. The true value of the field might contain a fraction of a penny which isn't in the display, but still in the value. When you add up all your values it's then wrong. Superman III all over again. ROUND ensures that each value is actually rounded.
Richard Rost 
           
5 years ago
If you're dealing with a calculated field in the query, you might not see any options under format. Access doesn't know how to deal with it.
Neal Groeling OP 
    
5 years ago
I always liked Richard Pryor, but not sure that was the right role for him. Thanks for the reason to use ROUND.
Richard Rost 
           
5 years ago
Oh, Superman III was an awful movie, and no, that was not a good role for Richard. He was a comedy icon and I loved his stand-up, but that movie was just silly. Sup 1 & 2 were good. 3 & 4 were garbage.
Neal Groeling OP 
    
5 years ago
Agree Completely! Still, it's interesting the number of people who were inspired by III to try skimming schemes of their own...
Richard Rost 
           
5 years ago
Yeah. They even mentioned it in the movie Office Space. LOL

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Expert 11.
 

 
 
 

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 2025 by Computer Learning Zone, Amicron, and Richard Rost. All Rights Reserved. Current Time: 2/11/2025 5:54:24 PM. PLT: 1s