help with quiering costing from multiple options (1 Viewer)

hi

I have a database called deviation report
i have 3 feilds ( drop down ) boxes called, with at least 10 options to pick from
and one field called cost
1.cause department code
2 problem cosed
3 componet codes


when i complete a form the 4 feilds must be completed

how do i go about getting the sum of the costs from any combination i chose
could be a lot

thanks

steve

Judging from the names of your combo boxes (drop down), they do not appear to be numbers. If I have that correctly, summing up the values (a numeric Function) will be quite difficult...

Assuming the combos are all numeric
NB it would be redundant to save the sum.

hi

sorry if I am confusing everyone
the first 3 fields are str fields
for example I could choose in combo one , either . engineering. purchasing , suppliers, assembly
in combo 2 I could choose , operator error, faulty goods, faulty drawings supplier error
the 3 combo box could be . bearings , castings, coolers , fabrications etc

each combo box as at least 20 lines . so there could be over 6000 different records

so if I select assembly, then operator error , then fabrication . to rework that item could cost 500£


this could be for any of the 6000 I can select from


how can I get the costs for each scenario. even when the 3 combo boxes are duplicated


steve

I think it would be more efficient to post a copy of the database with instructions to show the area involved and what you want as output. Your post seems a little light on details and readers(me for sure) seem confused with the real requirement.