Solved Access:Calculate #of days using 3 data points PleaseHelp!!

Microsoft Access 2010 - windows
May 8, 2013 at 09:17:02
Specs: Windows 7
Hello all,

Challenge: I want to calculate the number of days using two dates AND number of days allotted to complete job. This total needs to show every time we run the query. The first field is “DateOpen”, the second is field is “number of days allotted”, and the third piece of information needed is today’s date. Using these 3 pieces of information, we would like to be able to add a column within the query that performs the calculation that shows “Number of days past Timeframe of Completion”.
In other words how can I make the query calculate:
(OpenDate + # of days allotted to complete job) - today’s date = # of days past timeframe of completion.
Thanks in advance!


See More: Access:Calculate #of days using 3 data points PleaseHelp!!

Report •

#1
May 8, 2013 at 09:50:37
✔ Best Answer
You will need to put something like this in the 'Field' line in an empty column in query design mode. (You may need to change table and field names)

Number of days past Timeframe of Completion: (Date()-[Table1]![DateOpen])-[Table1]![number of days allotted]

A negative number means there are days remaining and a positive number are days over the 'days allotted.'

Law of Logical Argument: Anything is possible if you don't know what you're talking about.


Report •

#2
May 8, 2013 at 11:28:03
Normally we don't help with school work.

Answers are only as good as the information you provide.
How to properly post a question:
Sorry no tech support via PM's


Report •

#3
May 8, 2013 at 15:57:32
Thanks Newbie10,
I think it's trying to calculate the # days, but I keep getting "#Num!" for that column. ??? I've tried different format type without any luck. Any idea what could be causing this?

@wanderer - -I wish this was school work!


Report •

Related Solutions

#4
May 8, 2013 at 16:27:19
The field named 'DateOpen' needs to be a date field in your table and the field named 'number of days allotted' needs to be a number field in your table for this to work.

Law of Logical Argument: Anything is possible if you don't know what you're talking about.


Report •

#5
May 9, 2013 at 08:42:17
If you're questions were answered, please select the best answer so that others with similar questions know this thread is solved. Thanks.

Law of Logical Argument: Anything is possible if you don't know what you're talking about.


Report •

Ask Question