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

How to populate several date fields based on a date due.

P: 6
I'm very new to programming and although I've seen a similar post that addressed this in part, I am unsure how exactly to go about this. I know I can utilize the DateAdd function but don't know where this info needs to be inserted. I need to populate 12 different date fields based on a due date, but don't know if this should be done in the original table, or if I can do it in a form. When the data is being inputted I will have the due date, but for the purpose of creating the formula there is no specific date. Any advise would be greatly appreciated!
Aug 3 '10 #1
Share this Question
Share on Google+
3 Replies


Expert 100+
P: 107
It sounds like you want to use the DateAdd function, based on the due date.

You could put the calculation in a calculated field on a form, or you can put it as a calculated field in a query.

For these examples, let's say the due date field is called 'DueDate'.

In a query you would put the calculation on the Field row. It would be something like:

Two Weeks Past Due: DateAdd("d",14,[DueDate])

In a form you would put the calculation in the Control Source of a text field. It would be something like:

=DateAdd("d",14,[DueDate])

Let me know if you have difficulty finding the 'Field' row in a query or the 'Control Source' property on a form's text field.
Aug 3 '10 #2

P: 6
I made the change to a form in design view but when i changed to form view the field shows "#Error".
Aug 3 '10 #3

P: 6
I got it! Thanks - just left a character out. Thanks so very very much!!!
Aug 3 '10 #4

Post your reply

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