Random Numbers

[BenSteckler]

I am trying to have Access create a Random number but when I use the rand() function, it is not reconized. Any ideas?

 

[Jack Cowley]

rnd() is the function you are looking for. Access does not have a rand() function....

 

[mrabrams]

I use the following code "lifted" from Dev's site: http://www.mvps.org/access/queries/qry0011.htm

It works like a charm.

Michael Abrams

 

[BenSteckler]

Thanks for the reply, the only problem is that when I enter that md() function, it gives me an error saying that "sub or Function is not defined."

Any ideas on how to fix that?

Ben

 

[Atomic Shrimp]

You've misread rnd (r n d) as md (m d) - it's an easy mistake to make with this font.

[This message has been edited by Mike Gurman (edited 03-18-2001).]