Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

call a public function within query Access

Status
Not open for further replies.
studentcp

studentcp

Programmer
Feb 12, 2007
15
CA
I have a public function (Percentile) in the modules, when I call it in Query, Access gives me "Undefined function'Percentile' in expression". Thanks in advance.
 
Sort by date Sort by votes
Make sure your module name, is not the same
as your function.
I often prefix my modules with "mdl"
"mdlPercentile"

Is Percentile, a reserved word in SQL?

Try fPercentile (prefix function with "f".
Much easier to identify in code.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Kennelbloke
  • Solved
Split Function not working
Replies
3
Views
169
Kennelbloke
Kennelbloke
DarkOne72
  • Locked
  • Question
MS Access DoCmd.Transferdatabase Assistance
Replies
2
Views
1K
lameid
lameid
BFroeschlKC
  • Locked
  • Question
Publisher Automation from Access Frustration
Replies
3
Views
2K
dhookom
dhookom
M
  • Locked
  • Question
display a calendar with appointments in body of html email with access vba
Replies
1
Views
2K
SoftwareRT
SoftwareRT
Moss100
  • Locked
  • Question
Vba code I can call from a query to reformat text
Replies
8
Views
326
Moss100
Moss100

Part and Inventory Search

Sponsor

Back
Top