If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Crosstab Query - Column Heading Dates
I am running a crosstab query however the column heading with the dates is
not in order. Instead of 1-2005, 2-2005.etc, I am getting 1-2005, 1-2006, 1-2007, 2-2005. How can I get the dates to run sequentially at the top? The SQL code that I am using for the original query is: GROUP BY Format([Month],"mm-yyyy"), Thanks. -- Bob |
#2
|
|||
|
|||
Crosstab Query - Column Heading Dates
"Bob" wrote in message ... I am running a crosstab query however the column heading with the dates is not in order. Instead of 1-2005, 2-2005.etc, I am getting 1-2005, 1-2006, 1-2007, 2-2005. How can I get the dates to run sequentially at the top? The SQL code that I am using for the original query is: GROUP BY Format([Month],"mm-yyyy"), Thanks. -- Bob Bob, Your data is sorting in alphabetical order as the results of your format function are returning a string. Will the crosstab always contain the same month/year columns? If so you can use the Column Headings property to explicitly declare the headings in the correct order. You could also reformat your date to yyyy-mm. There are other solutions, which I will be happy to explain if these two are insufficient. Ed Metcalfe |
#3
|
|||
|
|||
Crosstab Query - Column Heading Dates
I am having the same problem, but my dates will change and I cannot have them
yy/mm. Can you please list the other options "Ed Metcalfe" wrote: "Bob" wrote in message ... I am running a crosstab query however the column heading with the dates is not in order. Instead of 1-2005, 2-2005.etc, I am getting 1-2005, 1-2006, 1-2007, 2-2005. How can I get the dates to run sequentially at the top? The SQL code that I am using for the original query is: GROUP BY Format([Month],"mm-yyyy"), Thanks. -- Bob Bob, Your data is sorting in alphabetical order as the results of your format function are returning a string. Will the crosstab always contain the same month/year columns? If so you can use the Column Headings property to explicitly declare the headings in the correct order. You could also reformat your date to yyyy-mm. There are other solutions, which I will be happy to explain if these two are insufficient. Ed Metcalfe |
#4
|
|||
|
|||
Crosstab Query - Column Heading Dates
I am having the same problem, but my dates will change and I cannot have them
yy/mm. Can you please list the other options "Ed Metcalfe" wrote: "Bob" wrote in message ... I am running a crosstab query however the column heading with the dates is not in order. Instead of 1-2005, 2-2005.etc, I am getting 1-2005, 1-2006, 1-2007, 2-2005. How can I get the dates to run sequentially at the top? The SQL code that I am using for the original query is: GROUP BY Format([Month],"mm-yyyy"), Thanks. -- Bob Bob, Your data is sorting in alphabetical order as the results of your format function are returning a string. Will the crosstab always contain the same month/year columns? If so you can use the Column Headings property to explicitly declare the headings in the correct order. You could also reformat your date to yyyy-mm. There are other solutions, which I will be happy to explain if these two are insufficient. Ed Metcalfe |
#5
|
|||
|
|||
Crosstab Query - Column Heading Dates
Is the output going to a form or report? What type of options are you
looking for? Why can't you have them yy/mm? If you are extra demanding about this, you may have to use some code to build the SQL statement in code with the Column Headings included. Duane Hookom MS Access MVP "JMalecha" wrote in message ... I am having the same problem, but my dates will change and I cannot have them yy/mm. Can you please list the other options "Ed Metcalfe" wrote: "Bob" wrote in message ... I am running a crosstab query however the column heading with the dates is not in order. Instead of 1-2005, 2-2005.etc, I am getting 1-2005, 1-2006, 1-2007, 2-2005. How can I get the dates to run sequentially at the top? The SQL code that I am using for the original query is: GROUP BY Format([Month],"mm-yyyy"), Thanks. -- Bob Bob, Your data is sorting in alphabetical order as the results of your format function are returning a string. Will the crosstab always contain the same month/year columns? If so you can use the Column Headings property to explicitly declare the headings in the correct order. You could also reformat your date to yyyy-mm. There are other solutions, which I will be happy to explain if these two are insufficient. Ed Metcalfe |
Thread Tools | |
Display Modes | |
|
|