Search results

  1. R

    Creating a Query to list all Months and Years from Jan 06 to Present date

    Oops, I guess I messed up there. Yup, you were right, it works great!!
  2. R

    Creating a Query to list all Months and Years from Jan 06 to Present date

    I tried your query and it works perfectly fine except that if you put a constraint on the 'Month' field, it will give you the Months until the current month in each year. What I mean to say is, this is the output that I get: Month_Year Expr1 January 2006 February 2006 March...
  3. R

    Creating a Query to list all Months and Years from Jan 06 to Present date

    yup, that makes sense. haha!! Thanks a lot!!
  4. R

    Creating a Query to list all Months and Years from Jan 06 to Present date

    Hi Boblarson and VilaRestal, Thanks for your quick replies. @Boblarson: I have another query that checks whether a tool has come in for repair or not according to its serial number. If the tool has come in for repair, it checks the manufacturing month of the tool and displays this data...
  5. R

    Creating a Query to list all Months and Years from Jan 06 to Present date

    Hi, I'm trying to create a query or code that would generate a list of months from January 2006 to the present date. Can anyone help me out with this? Example: January 2006 February 2006 ........ ........ June 2011 Thanks a lot, Romit.
Back
Top Bottom