Random Selection

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

John - 20 May 2006 21:16 GMT

Hi
I have a database, which at the moment I export into excel to achieve my
goal.
I have a table of email addresses under the field heading "Email", from
which I want to select a random email address "For a monthly draw", is it
possible to do this from a query? if SO, could you please share your
knowledge. If NOT, does anyone kow how this can be achieved?

Kind Regards

John

Reply to this Message

Wayne-in-Manchester - 20 May 2006 23:37 GMT

Answer here

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vbenlr98/html/v
afctrnd.asp

Hope this helps

Signature

Wayne

> Hi
> I have a database, which at the moment I export into excel to achieve my
[quoted text clipped - 7 lines]
>
> John

Reply to this Message

John - 20 May 2006 23:59 GMT

Wayne
Thanks for the reply

I have tried this approach but cannot it to work. Should I use this from a
form liked to the query or direct from a query. I need a bit more help here,
i'm not very good with VB or SQL. I would like the result to be shown in a
dialogue box whenI click a commnd button, obviously this is done from a form
but I cannot get it right.

Regards

John

> Answer here
>
[quoted text clipped - 13 lines]
>>
>> John

Reply to this Message