Scope of User Defined Function in Access

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I've built a user function in an Access Module and it works fine as called
from a query within the .mdb. My problem is that I'm trying to use Excel as
a reporting front end using an External Data link to the Query in Access and
I get an error while trying to connect - Undefined function 'AllocationRate'
in expression. Here's my function definition:

Option Compare Database
Option Explicit

Public Function AllocationRate(Start_Date As Date, End_Date As Date,
TargetMonthDay1 As Date, DaysInMonth As Double) As Double
....
End Function

Any thoughts??
 
Back
Top