DLookup help needed

[jbdailey]

I have the following statement for a field in a query which looks up the points awarded to a rider based on his rider number.<br><br>DLookUp(&quot;[Points]&quot;,&quot;[q_AMA_SX_RaceResults]&quot;,&quot;[RiderNumber]=&quot; & [R7] & &quot;&quot<br><br>The statement works fine but my difficulty is that one rider may ride more than one class (more than one record per rider).&nbsp;&nbsp;The DLookup function stops at the first entry for that rider and gives me the points for the first entry only.&nbsp;&nbsp;How can I get it to add the points for two or three entries?&nbsp;&nbsp;<br><br>I'm a beginner at this stuff so any help would be greatly appreciated.&nbsp;&nbsp;Thanks!

 

[Cornerstone]

Use DSUM instead of DLOOKUP

 

[jbdailey]

Looks like that's going to work out - Thanks!