Using Rnd() in an Append query

From: "Dennis Snelgrove" <dennis.snelgrove@xxxxxxxxxxxxxxxxxxxxxx>
Date: Wed, 11 May 2005 14:14:56 -0400

I'm trying to populate an Intersection table with several thousand random
records in order to give myself some data to work with during the
construction of the DB. I'm trying to use "int(Rnd(1)*50)+1" as the formula
to fill in a Score field, but it only calculates this once, then applies
that value to every record in the table. How do I get it to calculate a new
random value for every record?

Thanks...

.

Follow-Ups:
- Re: Using Rnd() in an Append query
  - From: Ken Snell [MVP]

Prev by Date: Re: ODBC connection
Next by Date: Re: how can I display the date from a number of seconds given?
Previous by thread: Divide Max of one column with value in current record
Next by thread: Re: Using Rnd() in an Append query
Index(es):
- Date
- Thread

Relevant Pages

Re: how can I search a field for a particular word
... Rgds ... > formula that will look in Column C, identify the word "USDA" and populate ... Prev by Date: ...
(microsoft.public.excel.worksheet.functions)
Select Case Question
... MsgBox "This Media is not supported by this fund" ... as is cboMedia. ... the message box will populate. ... Prev by Date: ...
(microsoft.public.access.formscoding)
Re: Update a cell with a specific value related to a date.
... MATCH finds the position of each value in each ray (0 means match ... INDEX finds the intersection of the two positions. ... Prev by Date: ...
(microsoft.public.excel.worksheet.functions)
Enter a date in a drop down box
... I'd like to set this up so when the user clicks on the arrow for the drop ... a calendar pops up and he/she can select the date to populate the ... Prev by Date: ...
(microsoft.public.access.forms)
adding date records
... I have climate data for ... field, therefore increasing the records in my table by the missing days, and ... then populate the corresponding data with a "-99" value, ... Prev by Date: ...
(microsoft.public.access.queries)