Good points Duane! I will work on this some more. I know how to use NZ. I haven't thought about saving the sales tax since we just use this to produce a quote and the work is eventually invoiced in our accounting system but I will give it more thought. Thanks for adding your insight!
Doyce---In MS_Access_Professionals@yahoogroups.com, <duanehookom@...> wrote :
Doyce, Unless there is some VBA in form, the value will not "store ... in a table". =Round(([LaborPrice]+[MatPrice]+[DeliveryChg])*DLookup("[SalesTaxRate]","[tblSalesTaxRate]"),2) as a Control Source will display but not store the value. Also, if LaborPrice, MatPrice, or DeliveryChg are Null, the calculation will result in Null. Duane Hookom MVPMS Access
From: Doyce
John,
DLookup works like a charm!! Thanks, I've never used that before but will in the future!!
Doyce---In MS_Access_Professionals@yahoogroups.com, <JohnV@...> wrote :
Doyce-
Unless tblSalesTaxRate is in the underlying query, you can't reference it that way. You could embed a DLookup in place of the reference sot SalesTaxRate.
John Viescas, Author
On Aug 14, 2014, at 7:14 PM, winberry.doyce@... [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:Hello friends,I need to calculate sales tax which is a percentage of a purchase total. I want to store the sales tax percentage in a table. Here is my formula but it is not working.=Round(([LaborPrice]+[MatPrice]+[DeliveryChg])*[tblSalesTaxRate]![SalesTaxRate],2)What is the correct way to reference the value in the SalesTaxRate field of my table?Doyce
__._,_.___
Posted by: winberry.doyce@roadsysinc.com
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (5) |
.
__,_._,___
Tidak ada komentar:
Posting Komentar