Question Total listbox column

[josephbupe]

Hi,

I am trying to obtain totals from two columns in the list box into text boxes on the main form, but my third argument is not working as expected.

The source of one of the tex boxes is:

=DSum("Airtickets","T_Training_Participants.ProgrammeID=Me.lstParticipants")

I want to sum only amounts of the records that equal or belong to a selected programme (ProgrammeID) in the bigger list box above.

Attached is my sample db.

I will appreciate your help.

Joseph

 

[bob fitz]

You could try:
=Nz(DSum("[Per-Diem]","T_Training_Participants","ProgrammeID=" & [lstProgrammes]),0)

 

[josephbupe]

Thank you Bob once again for your unreserved help.

Stay well.

Joseph