By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
445,841 Members | 1,757 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 445,841 IT Pros & Developers. It's quick & easy.

Calculating date fields in Access2003

P: 1
I am using Access 2003. I want to calculate the date in the following
formula

DateJoined 1/1/2006
LeaveAccrued
LeaveTaken 20
LeaveBalance

If the system date is 1/1/2007
Leave accrued should show 30
Leave Balance should show 10

How to construct the table fields for this.
Aug 4 '07 #1
Share this Question
Share on Google+
1 Reply


BradHodge
Expert 100+
P: 166
I'm not entirely sure what date you are trying to calculate. If you give me a little more information, I bet either myself or one of the others can help.

However, if you want a link with some good information on date calculations, try http://www.mvps.org/access/datetime/index.html

Brad.
Aug 5 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.