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 > TechHelp > Directory > Access > Invoicing > < Switch Function | Templates >
Back to Invoicing    Comments List
Sales Tax Upload Images   Link   Email  
Turner Sculpture      
2 years ago
Hello!
I am creating a simple database based on your invoicing video. Is there a way to make a query that calculates sales tax for only people with addresses in a certain state? Or to have a form display if Sales Tax should be applied to certain orders and then calculate it for me? For example, if the item is being shipped out of state then there is no sales tax. Or if certain items are sold there is no sales tax. Please Help!

Thank you!
Turner
Juan C Rivera             
2 years ago
Query and criteria
this way when tax change value you only update the table, but copy the value to you invoice in case 2 to 3 yrs later someone ask for a recipt it dont up date to current.  
Check out Developr 14 it maay help
Scott Axton            
2 years ago
To expand a little on Juan's comment take a look at the Query Criteria video.  Covered more in depth starting in Access Beginner 5

Taxes are a tricky critters.  Richard covers it in many different places throughout the courses.  If you go to the Access Index and do a search (CTRL-F) for Taxable you can find the courses and videos where that subject is covered.
Richard Rost             
2 years ago
Turner, sales tax can be very tricky. I start covering it in Access Expert 8, but remember that class is based on all the ones that come before it, and it continues in Expert 9 and several further classes. So I'd recommend starting with the Beginner lessons and working your way up.

I do have it on my TechHelp list to do a short video on Sales Tax, but there's a lot to it, and I can't promise how soon I'll get to that.

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

 
 
 

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 2024 by Computer Learning Zone, Amicron, and Richard Rost. All Rights Reserved. Current Time: 5/21/2024 5:17:17 AM. PLT: 0s