Hi
I have form with many Reports queries option (Page frame with almost 100 queries- crazy client).
In the top I have combo box for year selecting (how many .. in year...).
My question is:
1.
I have to get many times the year (iear=val(thisform.combyear.DisplayValue))
I can add method 'YearQuery' and to add the code 'return val(thisform.combyear.DisplayValue)', but I have to call thisform.yearquery().
It is not problem to do it few times but I want to know if there is shurt way (for example to add somewhere store 'thisform.yearquery()' to ty and I can type &ty


2.
Most of the queries The User can select '>' or '=' on the year selected.
Again, I will have to store the user choise in variable and to run the select with the variable.
Or even I can prevent the 'year':
So here is my dream:

*yt(1) return '='
*yt(2)return  '>'
*yt(3)return  ''
*select * from customer where year(datepurchase)=thisform.combyear.DisplayValue&&very long
**dream
select * from customer where &yt1(datepurchase)
**My biggest dream
store 'select * from ' to ssf
&ssf customer where &yt1(datepurchase)

I hope the principle very clear, I dont know If I used with the correct examples but my requirement understood.