I have an eligibility tracker database designed in access 2000. The employees have to process the applications within 10 business days. 1. How do you determine business days, weekends and holidays? 2. If I have the following fields: AppStatus, EligDay, EligDate, AppReceived, Reassess etc. AppStatus has a dropdown of (NEW, EAP, REACTIVATE etc.) How do I do the following calculations: When you select NEW from AppStatus dropdown, EligDay = EligDate – AppReceived When you select REACTIVATE from AppStatus dropdown, EligDay = EligDate -Reassess Thanks in advance! OCM

Let me look at your second problem first. If I read it correctly, you only need to put in those statements in the "afterupdate" property of the "Appstatus" drop down box. Just use "if statements" to check if it is true and do the appropriate calculations. Your first problem requires more work. Of course there are many ways to do this. I would assume that if its not a holiday and not on the weekend, then its a business day. You could create a table of all the holiday dates. Weekend dates are not needed here since Microsoft Access knows which days fall on weekends. Once the date is input, you can store it in a variable and then increase it by one day. The next step is to determine if this day is on the weekend or holiday. You can use dcount (goto help for this command syntax). This command will tell you if that date exists in the holiday table (this is your holiday check). The next step would be to determine if the date is on the weekend. Use weekday (again goto help for the syntax on this command) to determine if it is on the weekend. You can use these two checks and then do your appropriate action. Hopefully I haven't confused you too much.