Ms Acces Help Urgent!!

[Ben Reynders]

Hi,
Does sombody know how i can filter the contacts in my database table into two new table, one with the name prospects, one white the name none prospects. If you would look to the database, you would probably understand my problem.

[ITGURU]

I have added two different queries one for extracting and inserting Prospect record in Prospect table (qryMoveProspect) and other for non Prospect record in non prospect table (qryMoveNonProspect).

Hope this will solve your problem.

[Ben Reynders]

thx itguru, that solved my problem!