RAND between function

[sallyc]

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

 

[Uncle Gizmo]

Have another look in the book, you should see a "listing" something along the lines


Public Funtion RANDBETWEEN(bottom as String, top as string)

'Some code

End Function

 

[Uncle Gizmo]

BTW you will need to add the listing to a module in your DB