Hey guys,
New to the site, new to writing SQL queries and have no background in this type of thing.
But I've been googling my way to victory for the most part.

I'm struggling on probably a very simple problem.
I'd like to Sum the contents of a column, if a different value in the row is the same as in another... That was worded horribly - how about an illustration:

Table

Unit ID---------Value
-------------------------
10000-----------1000
10000-----------100
10010-----------300
10010-----------1000
10010-----------110
10010-----------300
10030-----------999
10030-----------1
10040-----------500
10040-----------400
10050-----------1200
10060-----------1000
10060-----------100


So basically I'm looking for an output when I run the script that shows
Value must >= 1000 after sum up with unit ID.Unit ID shown again if first value hit 1000
Unit ID---------Value
-------------------------
10000-----------1100 (1000+100)
10010-----------1000
10010-----------1100 (300+110+300)
10030-----------1000 (999+1)
10050-----------1200
10060-----------1100



And various other simplistic queries, but at this point I'm willing to admit that I haven't a clue what I'm doing.

Any help would be appreciated,
Thanks!