Free Lessons
Fast Tips
Topic Index
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
Microsoft Access Expert 11 Upload Images   Link   Email  
Neal Groeling      
4 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              
4 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      
4 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              
4 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              
4 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      
4 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              
4 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      
4 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              
4 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.

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

Copyright 2024 by Computer Learning Zone, Amicron, and Richard Rost. All Rights Reserved. Current Time: 5/22/2024 12:11:37 PM. PLT: 1s