Combo box-Selective addition

[reidn]

I need to create a form that displays projected scores, monthly scores, and daily scores for operators.

My idea is to use a combobox that draws in all of the variables I need: QtyInsp, RedTags and their respective dates.

Then the user needs to select a date range (eg. 7/1/2010-7/30/2010) and I need the total values between those dates to be placed into the equation-
(RedTags/QtyInsp)
And the resulting value to be displayed on the screen.

Is there anyway to do this? Is there a better way?


Thanks for all the help,

Reid

[reidn]

Figured it out