adding from combo boxes

[hockey8837]

I have a form based on one table which has two cbo boxes, [ProgramFeeIDFK] & [TravelFeeIDFK], that will select from the same fee list for the same record. The user can select the fee from a drop down with 4 columns, the bound column being the id for the fee.

I'm having the user enter data in a datasheet subform on a form for scheduling the program, so they'll fill out things like program name, fee, travel fee, etc.

Is there a way add up the 'fee' totals (column 3 of each combo box) from 'tbltravelingzoofees' in a form?

I thought maybe I could add them in a query, but don't really know what to put. I attached a shot of the query so you can see the relationships.

Thanks!

 

[GohDiamond]

how about naming the Calculated field TotalFees and then just adding the othe fields together in your query:
TotalFees:[TravelFeeIDFK]+[ProgFeeIDFK]+[Fee]

Cheers!
Goh