Randomly select a % of records run from a query

[Groundrush]

This is GROSSLY incorrect

LOL

I understand your typo though, so all is good, but BOY is that wrong

What's wrong, the typo, my query or both?

I see my typo so perhaps I should't try rushing too many things at the same time, will clear my head & try again

I meant returning 10% from the following values

10% of 165 records is 16.5 - running query returns 17 records
10% of 29 records is 2.9 - running query returns 3 records
10% of 77 records is 7.7 - running query returns 8 records

These results seem correct to me, am I still missing something?

 

[namliam]

The typo my friend, the typo, the (rather obvious) extra %

 

[Groundrush]

The typo my friend, the typo, the (rather obvious) extra %

Thanks

I sheepishly looked for a way to delete my post without giving the game away but I was too deep in the mess & could not do anything else but this.....


Cheers