? Flagging records, or naming cells in part of a column...

[magicdust]

Hi there.

I am preparing data for some telemarketing for 4 people.

I have a field called 'record owner' in which I want to allocate records to each caller.

How can I select 200 records and name the record owner 'linda', then the next 200 and name 'helen' etc. So tomorrow they can filter by their name and get their allocated records.

Many thanks in advance...

Magic

 

[PHV]

You may try something like this (SQL code):
UPDATE yourTable SET [record owner]='linda'
WHERE yourPK In (SELECT TOP 200 yourPK FROM yourTable WHERE [record owner] Is Null)

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886