Error On Calculation using DLookup

Leesha
BronzeLounger
Posts: 1487
Joined: 05 Feb 2010, 22:25

Error On Calculation using DLookup

Post by Leesha »

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)
You do not have the required permissions to view the files attached to this post.

User avatar
HansV
Administrator
Posts: 78454
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Error On Calculation using DLookup

Post by HansV »

Does it help if you change

[Me.Contract18TierTotalFeePercent]

to

Me.Contract18TierTotalFeePercent
Best wishes,
Hans

Leesha
BronzeLounger
Posts: 1487
Joined: 05 Feb 2010, 22:25

Re: Error On Calculation using DLookup

Post by Leesha »

You are a wiz!! Thanks so much Hans, as always I really appreciate it!
Leesha