Hi all,

I've only ever had to use basic queries so might need some help from the query GURU's.

Senario: VB6 (ADO)

I have a table with the following fields
ContractID
EmployeeID
Date
Component#
Amount


1st
I need to SELECT all records from the table where the first character of the 'ContractID' = "2" or "M" and the 'Component#' is >50.

2nd
Then I need to check the 'EmployeeID' and 'Date' from each of the records in the query result recordset to see if there is a record in the original table that has the same 'EmployeeID' and 'Date', but has a Component# <50.

3rd
Any matching records that have a Component# <50 need to be deleted.

Lost yet?....I am!. I think I will need several Queries but I'm not sure how to feed the result of one query into another. Come on GURU's .... show me the money!