Hi,
I'm using the formula below to calculate sales tax for a store. I get the an error that is in the attached screenshot. I have checked all spellings an even resorted to copy and pasting them in the Dlookup section but nothing works. What am I doing wrong?
Thanks!
Leesha
Me.RentFeeSalesTax = Round([Me.Contract18TierTotalFeePercent] * (DLookup("[Sales Tax]", "qryContract18And20TaxesLookup")), 2)
Error On Calculation using DLookup
-
- BronzeLounger
- Posts: 1488
- Joined: 05 Feb 2010, 22:25
Error On Calculation using DLookup
You do not have the required permissions to view the files attached to this post.
-
- Administrator
- Posts: 78545
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Error On Calculation using DLookup
Does it help if you change
[Me.Contract18TierTotalFeePercent]
to
Me.Contract18TierTotalFeePercent
[Me.Contract18TierTotalFeePercent]
to
Me.Contract18TierTotalFeePercent
Best wishes,
Hans
Hans
-
- BronzeLounger
- Posts: 1488
- Joined: 05 Feb 2010, 22:25
Re: Error On Calculation using DLookup
You are a wiz!! Thanks so much Hans, as always I really appreciate it!
Leesha
Leesha