I need to set up a query in access that includes a random number generator (the random numbers should be 7 digits).

I tried the Rnd function but I want only integers (no decimals, etc)

Any suggetions would be appreciated.

Polar Bear

Re: Visual Studio Tools for Office 2008 (Pre-release) query to include a random number generator

Daniel Molina - MSFT

Hi Polar Bear,

This is probably a question for which you will get a better answer in the Access developer newsgroups, as this forum is forums is intended only for VSTO-related questions.

Access newsgroups: url=/msdn-files/028/201/016/topic.xml