I keep getting "Undefined Function" error when I input the "WorkingDaysFC" Function in a query.
This is the Function:
DetailsPublic Function WorkingDaysFC(LRD_Walid As Date, Status_Date As Date) As Long
Dim D As Date
WorkingDaysFC = 0 D = LRD_Walid While D <= Status_Date If Weekday(D) > 1 And Weekday(D) < 7 Then WorkingDaysFC = WorkingDaysFC + 1 End If D = D + 1 Wend End Function
Sami Shamma
@Reply 2 years ago
How are you using it in the query?
Adam Schwanz
@Reply 2 years ago
Just to confirm, is this inside a module?
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Visitor Forum.