sorting calculated expressions

[icemonster]

hi

i have two calculated expression fields

the first is when a review should be done upon hiring and the other is the succeeding review afterwards and it goes like this:

initial review: IIf([TypeofHomemaker]=1,DateAdd("m",3,[HireDate]),IIf([TypeofHomemaker]=2,DateAdd("m",6,[HireDate])))

VisitDate: IIf([SupervisoryVisitDate] Is Null,[InitialVisit],IIf([TypeofHomemaker]=1,DateAdd("m",3,[SupervisoryVisitDate]),IIf([TypeofHomemaker]=2,DateAdd("m",6,[SupervisoryVisitDate]))))

now when i try to sort this, i get a parameter value. can anyone help me? thanks

 

[Brianwarnock]

Were you doing this in SQL and trying to say Order By visitdate, if so that doesn't work, you have to quote the formula.
You might find it simpler to do the sort in a second query.

Brian

 

[icemonster]

what do you mean 2nd query? make a new one out of this and sort it through that? what about if it's in a VBA?

 

[Brianwarnock]

This is the queries forum, assumed that you were talking straight queries not SQL strings, guess you must just take the first option.

Brian

 

[icemonster]

thanks. it worked! never crossed my mind to do the secondary query.