Hi guys

I have designed a system with excel as a frontend and Access as a backend. The main table stores information about each case like recdate,Procdate, Product,daystaken etc. Now I want to design a form from where the user can select the startdate and enddate from the dropdownbox and when the Enter button is clicked then it should store the "daystaken" fro each record whose recdate>=startdate and <=Enddate.

e.g id recdate=09/10/2011 and Procdate=11/10/2011 then daystaken field will store 2(so it is same like finiding the networkdays in excel).

I hope anyone can help me to figure it out.

Thanks