var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Is it possible to assign an expression to an alias?
Hallo. This is my first post but when I have some db problem google often brings me here
Now I make an example of my problem.
Let's suppose I want to make a sum on a field based on last month records.
This is my code.
However I'd like that if I run this code on march, my alias would be equal to "Feb 2011", if I run on may it would be "Apr 2011" and so on.
sum(IIf(format(date_field,"yyyymm")=format(dateadd("m",-1,now()),"yyyymm"),my_field,0)) as last_month ....
Is it possible to assign to an alias an expression like
? Thanks in advance.
Last edited by john_revelator; 03-21-11 at 19:12.