I have a SQL function that take input params and return a single value. I want to call this function from an Access Form/Report and have the value displayed in a control on the Form. The input params for the function comes from data in the table the Form is bound to.
I can get the form to show a record set based on a control on the form from stored procedures but I don't understand how to display the data directly from a SQL function on the .adp Form. How do I do this?