Share via

Undefined function 'DMedian' in expression

Anonymous
2018-02-28T01:29:17+00:00

I'm trying to use the modem to calculate the median from https://msdn.microsoft.com/en-us/library/dd789431%28v=office.12%29.aspx?f=255&MSPPError=-2147217396 in Access 2007. I pasted this code into a new modem, saved it, closed and restarted the database, but I  still get the error message "Undefined function 'DMedian' in expression" when i want to use in a query. Please help.

Microsoft 365 and Office | Access | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

Duane Hookom 26,825 Reputation points Volunteer Moderator
2018-02-28T03:48:05+00:00

Did you save the code in a standard module?

Did you name your module something other than DMedian?

Can you share more about how you used the function?

Was this answer helpful?

1 person found this answer helpful.
0 comments

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2018-03-01T18:27:45+00:00

    I renamed the module to D-Median and now it works. Thank you.

    Was this answer helpful?

    0 comments