Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Access 2000 Calculations

Status
Not open for further replies.
OCM

OCM

MIS
Sep 12, 2002
220
US

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!
DKD
 
Status
Not open for further replies.

Similar threads

TopTeller
  • Locked
  • Question
Is ms-access a true recommendation for students to use with VB? 2
Replies
4
Views
235
SamBones
SamBones
DBServices
  • Locked
  • Question
Need help on using SQL Server tables linked to Access as a front-end
Replies
3
Views
188
Darrylles
Darrylles
zandsc1
  • Locked
  • Question
Front End / Back End with Access
Replies
5
Views
300
Olaf Doschke
Olaf Doschke
Bubsa
  • Locked
  • Question
Access Application to SQL
Replies
2
Views
75
PRPhx
PRPhx
DBServices
  • Locked
  • Question
advice on software to use to take cash in Access
Replies
1
Views
97
Thargy
Thargy

Part and Inventory Search

Sponsor

Back
Top