Arthur Fuller
fuller.artful at gmail.com
Sun Jan 6 10:51:26 CST 2008
Maybe I'm just having a senior moment, but I can't figure out why I'm getting the results I am. This is a really simple task. I have a system parameters table containing two tax rate fields, GST and PST, whose values are .05 and .08 respectively. I wrote a pair of wrapper functions to return these values: Function GSTRate() As Long GSTRate = DLookup("GST", "Company") End Function The function should return 0.05 but instead it returns zero. In the immediate window, if I type this: ? Dlookup("GST", "Company") I get back 0.05 Why doesn't the function return the same value? I even tried multiplying it by 100, but it still gives me zero. What am I doing wrong? TIA, Arthur