Query sum from value list field

[jree3000]

I am trying to set up a query that calculates a sum from a text field that uses a value list. The values are "5mil", "10mil" and "20mil". I want the query to sum these numbers at quantities of 5, 10, and 20 respectively. How can I get the query to add the proper numbers based on the value selected?

[ranman256]

In the 'combo' box ,user picks 5,10 or 20.
Then the function can use the choice in the combo to pull the results.
'the Dsum() function sums the total miles after user updates the combo

cboMiles_Afterupdate()
txtTotal = Dsum("[miles]", "table", "[CataMiles] = '" &  cboMiles & "'"

end sub

[jree3000]

Thank you!