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

[due_date] = [date_opened] + 40 days

P: 1
Hi
In Access 2003 & 2007 I have a nice simple database for tracking documents and due dates.
However I can't get the [due_date] field to calculate correctly
[due_date] = [date_opened] + 40 days

Can someone please assist with the correct expression/formula - once I have seen the correct answer I will be able to understand in future.
Thanks and best regards
S.
Sunny South Africa
Oct 2 '06 #1
Share this Question
Share on Google+
3 Replies


PEB
Expert 100+
P: 1,418
PEB
Hi,

try:

[due_date] :[date_opened] + 40

or

[due_date] :dateadd("d",[date_opened],40) or sth like this! check the Access help about dateadd function!

:)

Best regards

Hi
In Access 2003 & 2007 I have a nice simple database for tracking documents and due dates.
However I can't get the [due_date] field to calculate correctly
[due_date] = [date_opened] + 40 days

Can someone please assist with the correct expression/formula - once I have seen the correct answer I will be able to understand in future.
Thanks and best regards
S.
Sunny South Africa
Oct 2 '06 #2

P: 1
Hi there,

I am a new member, just registed a while a go. Also newbie to Module/VBA coding. I have been creating access database by coping and paste from simple access database sample from other users which I can possibly find on this thescripts forum also from Access Worl Forum mainly.

Due date is one of things that I would like to happen on my personal contact database, however it doesn't seem easy to me to work it out. I have seen codes in your response but they all blind me because I just don't know what I should start with.

Could you be possible attaching me simple access database example please?

Hopefully, it will not take evermuch time of you.

Thank you so much for your assistance.

Best,
Oct 3 '06 #3

PEB
Expert 100+
P: 1,418
PEB
My frien, this isn't difficult!

Go in queries, Query design, Invoke your table with your dates inside...
Remember that open_date is date from a table!

So add the columns that you want to see...

In the same row with Field Names Copy and Paste the expression!

Change only [Due_date] with your own date... IF not this will work but will ask you for [Due_date] as parameter that you have to introduce...

And it's everything...

Take care my frien!

:)
Oct 7 '06 #4

Post your reply

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