DCount against two criteria, value and employee

[JamesMF82]

Hi,

I am looking to create a summery on a dataset. I have

Employee ID Duration
1234..............10
1234..............20
1234..............8
1234..............9
1236..............40
1236..............2
1236..............20
1236..............10

I want to summerise the data to calculate the number of times an employee has an entry under 20 and the calculation. e.g.

Employee ID....Count.....Sum
1234...............3...........27
1236...............2...........12

I used a DCount however this does not separate the employees. Currently using
Count Of Visits: DCount("[Duration]","Test Query","[Duration]<20 AND [Employee ID] = [Employee ID]")

Any help would be amazing!