Adding up numbers listbox - but not adding duplicates

[WebFaktor]

Hi - I have an access 2000 form / list box that users can drag and drop entries into. each entry is uniquely identified by the contents found in column 1. each entry has a number/time association found in column 2.

why I am writing is to try and find out how I can add up the number/times found in coulmn 2, but only adding them once should someone drag and drop them to the list two or more times. In my circumstance they need to be able to add an item more than once, as this database is designed to establish training agendas.

For example:
Coulmn A:......................Column B: (= Minutes)
Course 1........................180
15 minute break.............15
Course 1........................180
30 minute break.............30
Course 2........................360
15 minute break.............15
Course 2........................360
15 minute break.............15
Course 2........................360

how I am doing my calculation, is one at a time as they drag and drop each item with the following formula placed in a text box on the form.

=Format(DSum("[MMModTime_Minutes]","Qry_Ma_CourseMMMods_Temp")/60,"00.00")

They don't necessarily need to be added up one at a time - just so that a user can at sometime before leaving the form see what the total time is.

Advance thanks,

 

[WebFaktor]

I figured it out. . .

All I needed do was to query the field with a unique query and reference that query/field in a text box on the form.

Thank you any way,

WF