- Local time
- Today, 01:37
- Joined
- Feb 28, 2001
- Messages
- 27,156
If it is publicly declared in a general module, then perhaps something like this:
Note that this WILL NOT WORK in a query if declared in a form or report Class module.
"Publicly declared" means that the keyword PUBLIC precedes the word FUNCTION in the declaration of the function. See, for example, my code in post #16.
Code:
UPDATE tblX SET fldX=RoundUp(fldx) ;
Note that this WILL NOT WORK in a query if declared in a form or report Class module.
"Publicly declared" means that the keyword PUBLIC precedes the word FUNCTION in the declaration of the function. See, for example, my code in post #16.