Randomly choose a data from a field.

[HampasLOUpa]

I'm planning to create some sort of a randomizer app. I want my DataPage to randomly select a name from a field in my table. Any idea to do this?

[AnchovyXL]

Hi,

There is a very simple solution for that. 
First, change the form element of the field you want to have the random name to calculated value.

Then, put this SQL Code:

SELECT TOP 1 <Field_Name> FROM <Table_Name> 
ORDER BY NEWID()

Change the Field_Name to the name of the field that you want to get the value from. Same as the Table_Name.

This should do the trick.

[HampasLOUpa]

Hi,

I tried using it and the randomizer worked. However, the problem here is that all it gives me a name that was previously called. I think this needs further code to limit the randomly selected data.

Thanks!

[MayMusic]

In Report DataPages you have the option to check "Random  Order" in " Search and Report Wizard - Results Page Options " screen and choose to return only one record.