Sephiroth0327
Registered User.
- Local time
- Today, 05:17
- Joined
- Aug 18, 2009
- Messages
- 19
Hi All!
I am new to the forums here and am running into a small problem with my Crosstab query. Hopefully someone can point me in the right direction.
My Crosstab Query is very simple. My column header is a field named "Region" and my row header is a field named "Created". The "Created" field is a Date field. My query is designed to break the data out by day.
For example, it should look like this:
LOB 7/31/2009 7/30/2009 7/29/2009 etc...
RET 100 121 92
The Crosstab query automatically orders the "Created" columns in Ascending Order meaning that my 7/31/2009 appears as the last column instead of the 1st.
I have researched this issue on the forum, but the only response I found was to add the fixed values in the query properties. This solution does not work for me because the query is returning 1 years worth of data and the dates will change depending on when I run it.
Is there anyway to modify the query to order the columns in descending order?
I am new to the forums here and am running into a small problem with my Crosstab query. Hopefully someone can point me in the right direction.
My Crosstab Query is very simple. My column header is a field named "Region" and my row header is a field named "Created". The "Created" field is a Date field. My query is designed to break the data out by day.
For example, it should look like this:
LOB 7/31/2009 7/30/2009 7/29/2009 etc...
RET 100 121 92
The Crosstab query automatically orders the "Created" columns in Ascending Order meaning that my 7/31/2009 appears as the last column instead of the 1st.
I have researched this issue on the forum, but the only response I found was to add the fixed values in the query properties. This solution does not work for me because the query is returning 1 years worth of data and the dates will change depending on when I run it.
Is there anyway to modify the query to order the columns in descending order?
