var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Here is my query
Select iif(month(curdate)=1, JAN, FEB) as x From invoice
Currently, I have the column named x, is it possible to name it based on the month of curdate? So if the column is populated with January data, I need the column to be name January instead of x.
What are you trying to do here? I get a sneaking suspicion I should be pointing you towards a crosstab query...
oh yeah... documentation... I have heard of that.
*** What Do You Want In The MS Access Forum? ***
invoice table contains column Jan, Feb,....., Dec. When I query it, I need to show current month's column first and backward. For example, it's August now so Aug needs to be the first column, then Jul, then Jun......
Log in with your username and password
Forgot your password?
Subscribe to dBforums Brief to receive special offers from dBforums partners and sponsors