Hi
I am trying to run a rand between function. I don't have the option to select this from the expression builder, but have found the formula in a book - RANDBETWEEN(bottom, top). However even using this it still doesn't work and I get the message "Undefined function 'randbetween' in expression"
I found a help topic which said that said I may need to install msowcf.dll I found this in programme files and tried to register it by putting regsvr32 c:\program files\microsoft office\office\msowcf.dlland I get "load library(C\Programme files) failed - The specific module could not be found"
Does this mean it's already registered, if so why doesn't my function work, or is the dll file in the wrong place, or is the query just wrong???!
Any help at all on this much appreciated as I really need to be able to do random selections!!
Thanks a lot
Sally
I am trying to run a rand between function. I don't have the option to select this from the expression builder, but have found the formula in a book - RANDBETWEEN(bottom, top). However even using this it still doesn't work and I get the message "Undefined function 'randbetween' in expression"
I found a help topic which said that said I may need to install msowcf.dll I found this in programme files and tried to register it by putting regsvr32 c:\program files\microsoft office\office\msowcf.dlland I get "load library(C\Programme files) failed - The specific module could not be found"
Does this mean it's already registered, if so why doesn't my function work, or is the dll file in the wrong place, or is the query just wrong???!
Any help at all on this much appreciated as I really need to be able to do random selections!!
Thanks a lot
Sally