Hi,

I have a table with project costs and each cost (record) has a resource code. I want to pull out all costs, where the resource code matches any one of eight resource codes specified. Then move those matching records to a different table.

ie

SELECT * from tbl WHERE RCode = "CHR" or "TRD" or ....(X8 Resource Codes)

Then do the same for records using another set of resource codes and transfer these to a different table again.

What is the best way, or any way, of doing this. Any code example would be appreciated.I am using VB6 and ADO.

Cheers