Hi,
I have a two fields in my table: 1) Dt_closed 2) Fileprep_end_dt
I'm trying to create a calculating field called "Days_in_NG" by using this logic in query design. If "Dt_closed" is null take Today's Date minus "Fileprep_end_dt." However, if "Dt_closed" is NOT null take Today's Date minus "Dt_closed". Please help! Thank you so much!
LH
Last edited by Dhoang25; 06-22-2011 at 09:36 AM.
Days_in_NG: IIF(IsNull(Dt_closed),Date()-Fileprep_end_dt,Date()-Dt_Closed)
Is your code running too slowly?
Does your workbook or database have a bunch of duplicate pieces of data?
Have a look at this article to learn the best ways to set up your projects.
It will save both time and effort in the long run!
Dave
Thank you!!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks