I currently have a Query that calculates out a date based on a field in my primary table. I want to have another field query on that one to bring in dates from other fields in my primary table. Here is what I have so far:
AnnualCalc: IIf([LastAnnualDate]>=DateSerial(Year(Date()),Month(Date()),1) And [LastAnnualDate]<DateSerial(Year(Date()),Month(Date())+1,1),[AnnualValue],"")
The LastAnnualDate is calculated on the AdmissionDate, and the AnnualValue returns the calculations from text back to date form. What I would like to have happen is to have the AnnualCalc pull dates from LastAnnualDate between 10 and 14 months prior to the current month. If there is a date that falls between the 10 and 14 months prior, then I want the AnnualValue to show, otherwise, nothing. Ideally, I would like to have the same parameters for another field, N_Annual.
Thanks in advance.