How do I specify the number format for the returned variable.
the following code will compile if I remove the (5,3).
The view works fine in oracle but Access doesn't want to display the decimal values in a combo box and instead displays a bunch of chinese type characters when I use the results as a recordsource.
I've tried converting the results to character format but then I can't sort the results....aargh!
create or replace
FUNCTION FN_NEW_TEST
(Lat Number)
RETURN NUMBER(5,3) AS
BEGIN
RETURN Lat;
END;
Start Free Trial
