Good Morning All;
I have some criteria in my query which shows a calendar year as follows:
But what I need to do is show the fiscal year from my table; tbl_year_financial, from the attached image.
How can I change my query criteria to look at the table: tbl_year_financial; to pull back records for my fiscal years?
Your help is very much appreciated.
Kind Regards
Tor Fey
I have some criteria in my query which shows a calendar year as follows:
Code:
Quarter1: IIf(DatePart("q",[tbl_tf_ben_interview]![TF_Ben_Date_Interview_under_Caution])=1 And Year([tbl_tf_ben_interview]![TF_Ben_Date_Interview_under_Caution])=2017,1,Null)
But what I need to do is show the fiscal year from my table; tbl_year_financial, from the attached image.
How can I change my query criteria to look at the table: tbl_year_financial; to pull back records for my fiscal years?
Your help is very much appreciated.
Kind Regards
Tor Fey