Apply Filter Help

[gator9]

Can anyone tell me how I can apply a filter to a form so that the filter will randomly pick 50 or 75 accounts that need to be worked. I have about 593 records and what I would like to do is apply a filter that will ether split the accounts that need to be worked by day or upon applying the filter randomly without duplicating them pick 50 to 75 which ever I choose. Can anyone tell me how I can do this?

PS I am new to VB! Thanks

Sincerely,

Charles

 

[zevw]

Well if there is a criteria on what you want to work on, then built your select statement query based on your specs, or create a Temp table with the info you want to work on and update it back in the main Table.

I think this is what you want.

 

[Rolliee]

open a recordset with the following:

for dates:

SELECT * from MyTable WHERE MyTable.date between ((now() - 12) and (now() - 8));

or set dates from a text box or even do a random number set.

Rollie