force one row at a time even if others are equal?

[NonVBATwit]

I am making a Scheduling package for radio and I am all but finished.

My last problem is this.
Each client can have as many ads as they like. Each ad is assigned a
rotation %, that is the total % share of times it will play compare to all
other ads for that client.

How it works is the assigned % is minus from the actual % and then what I
want to do is make the Min of the result be the next to schedule. The
problem arises when
All spots have an equal amount schedule and an equal % assigned to schedule,
what happens is it trys to schedule all the spots that are equal instead of
just the one at a time which is what I want.

I know you can limit a qry to return on the top 1 result, but it doesn't
seem to work in this instance because the result its reurning has equal
values in the rotation result feild and different numbers in the ad number
feild.

can anyone tell me how to force the darn thing how to return only one row at
a time even if others are equal?

 

[JL]

Hi,
I do not know if this will do the trick for you. You can use the first
function to return the first record on the query.

select first([Table1].[Field1]), first([Table1].[Field2]), ...
from Table1;