I am using DateDiff to determine the number of days between arrival in Canada and when they show up at the social service agency: FV: Nz(DateDiff(“d”,[DateEntered],[MeetingDate]),0). This is functioning as expected.
I then use the Switch Function in a new query on FV to determine time frames, less than one year, 1-2 years, etc and I am getting #Error#
FrstVst: Switch([FV]<=365,"-1 Yr",[FV]<=730,"+1 Yr",[FV]<=1095,"2 to 3 yrs",[FV]<=1825,"3 to 5",True,"More Than 5 Yrs")
I have used something very similar for age ranges in the past and the syntax is essentially identical, so I'm stumped.
The only difference is that the age query is using switch for columns in a crosstab and FrstVst is filling in values in a single column. I set the properties for FV in its source query as General Number