this is a follow up to question:
I have a datediff using this:
Day Count: DateDiff("d",(Select Max(DisbRecdDate) From tblDisbursement_Amounts As T Where T.DisbRecdDate < tblDisbursement_Amounts.Di
It works fine but I need to tweak it.
You can see from above that the DateDiff is the days between [DisbRecdDate] according to a Where condition of: T.DisbRecdDate < tblDisbursement_Amounts.Di
What I need now is to add another condition for the DateDiff. The condition is to return the DateDiff from tblDates_impt."Execution Date of Financing Docs" to [DisbRecdDate]. The tblDates_impt."Execution Date of Financing Docs"date is #8/6/2014# as you can see in the tblDates_impt.
Here is how I would need the output (see column far right, Day Count, the bold, underline 90)
Type Disb Amt Expected Disb Date Total Disbursement Disb RQ Date Draw Down Rec'd Day Count
JBIC $0.00 04-Nov-14 $0.00 8/6/2014 11/4/2014 0
JBIC $98,000,000.00 04-Nov-14 $98,000,000.00 10/1/2014 11/4/2014 90
JBIC $25,000,000.00 11-Dec-14 $25,000,000.00 11/10/2014 12/11/2014 37
The 90 is bolded and underlined in the tableabove (and this table is Q.Disbursement in the db) in last column "Day Count". It is the Day Count from tblDates_impt."Execution Date of Financing Docs" to [DisbRecdDate]. The same would apply for the other .Type (NEXI, Uncovered)
thank you. Please feel free to ask if not clear.