Understood, Jim, re: not putting a calculation in table. Thank you.
Is there an example you can share with me regarding how this would work, because I just tried it in both a report (which I couldn't figure out how that works) and a form (which kindofsortof gave me what I was looking for, however, it doesn't pull the info from the table as I was hoping for). It opens a dialog box (which works if you put in "Enter Parameter Value"), but I was hoping the value could be taken directly from [ActualImplementation] and the difference populated into a separate field?
Hope this isn't too confusing?
From: Jim Wagner <luvmymelody@yahoo.com>
To: "MS_Access_Professionals@yahoogroups.com" <MS_Access_Professionals@yahoogroups.com>
Sent: Tuesday, September 13, 2011 10:52 AM
Subject: Re: [MS_AccessPros] Access 2003 - Need to deduct one cell from another...
Florence,
You do not really want to do calculations in a table or store the calculations in a table. The best place to do calculations would be on a report or a form. There are several ways to calculate. days, months and years. here is one for days
=DateDiff("d",[PlannedImplementation],[ActualImplentation])
You would put this expression in a control on a form or a report.
Jim Wagner
________________________________
________________________________
From: florenceps1217 <florenceps1217@yahoo.com>
To: MS_Access_Professionals@yahoogroups.com
Sent: Tuesday, September 13, 2011 7:40 AM
Subject: [MS_AccessPros] Access 2003 - Need to deduct one cell from another...
Access 2003.
I need to have one cell "DaysLate" calculate "PlannedImplementation"
date from the "ActualImplentation" date.
Is that possible?
Thank you and sorry I'm such a newbie with these basic questions, but
sure do appreciate the help.
Florence
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
Tidak ada komentar:
Posting Komentar