Unique record that meets a criteria for each record

Database

Unique record that meets a criteria for each record

Hi I have a table similar to the below one that contains many different RecordIDs.

I am trying to create a query that will only return one record_id when the TRANSFER is below 0 for EVERY date between two set dates. 

so in the table below if i ran the query between 01/07/2015 and 31/07/2015 i would get one RECORDID = 12 however if i run between 01/07/2015 and 31/08/2015 i would get no record back






RECORDID TRANSFER DATE
12 -50 01/07/2015
12 -947.00 02/07/2015
12 -438.00 03/07/2015
12 -633.00 04/07/2015
12 -496.00 07/07/2015
12 -227.00 08/07/2015
12 -1,313.00 10/07/2015
12 -1,369.00 14/07/2015
12 -1,173.00 16/07/2015
12 -1,316.00 17/07/2015
12 -97.00 21/07/2015
12 -1,250.00 22/07/2015
12 -934.00 23/07/2015
12 -620.00 24/07/2015
12 -305.00 25/07/2015
12 -700.00 28/07/2015
12 -159.00 29/07/2015
12 -490.00 30/07/2015
12 -710.00 31/07/2015
12 6,069.00 01/08/2015
12 6,985.00 02/08/2015
12 8,703.00 04/08/2015
12 9,672.00 05/08/2015
12 17.00 06/08/2015
12 6,459.00 07/08/2015
12 151.00 08/08/2015
12 8,225.00 11/08/2015
12 3,066.00 12/08/2015
12 5,390.00 13/08/2015
12 4,215.00 14/08/2015
12 9,410.00 15/08/2015
12 2,582.00 18/08/2015
12 8,067.00 19/08/2015
12 841.00 21/08/2015
12 1,890.00 22/08/2015
12 7,148.00 25/08/2015
12 1,364.00 26/08/2015
12 5,221.00 27/08/2015
12 8,946.00 28/08/2015
12 2,044.00 31/08/2015
1 REPLY

Re: Unique record that meets a criteria for each record

Sorry the table didn't look like that when i pasted it in from excel!