Select Count Random

M

Markus

Hallo

I have this select count query which i need to change into a random count
what do i need to change to make it select random. What it does it count a
Qty of PIN numbers. But i need it to do a Random Select of a Qty PIN numbers

(Select Count (Tmp.Pin_Number)
FROM [Sales Pingen3] As Tmp
WHERE Tmp.Pin_Number <= [Sales Pingen3].Pin_Number)

Thank you

Markus
 
J

JohnFol

The only way to do this is to build up the SQL statement using VBA code.

What do you do with the results of the query?
 
M

Markus

It will be Printed. Maybe to give you a bit more of a backgroud of what it is
I have a SQL server with the table with PIN Numbers of calling cards. And a
front end front end programe that will request the PIN number from the SQL
server that works fin but the problem is when 2 people request the same
Calling Card at the same time they will get the same Pin number and thats not
allowed. So i am tring to find some solution to the problem

Markus

JohnFol said:
The only way to do this is to build up the SQL statement using VBA code.

What do you do with the results of the query?


Markus said:
Hallo

I have this select count query which i need to change into a random count
what do i need to change to make it select random. What it does it count a
Qty of PIN numbers. But i need it to do a Random Select of a Qty PIN
numbers

(Select Count (Tmp.Pin_Number)
FROM [Sales Pingen3] As Tmp
WHERE Tmp.Pin_Number <= [Sales Pingen3].Pin_Number)

Thank you

Markus
Click to expand...
Click to expand...
 
Top