how to sort columns in cross tab query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have months - text data such as Oct-2004, Nov-2004, Dec-2004 that I want to
sort from in that order. I know you can customize the sort by using Orderby
commend, but I don't know where to input that commend.
 
I tried to convert text to date but it gave me 10/1/2004 vs Oct-2004. I want
to see Oct-2004 in my column heading.
 
Have the data stored in the table in a dateTime field. in the form or report
have the format as you wish to see it.
This will display YourDateField in the format you want --
Format([YourDateField],"mmm-yyyy")
 
I was successful in formating the date in the table, but the cross tab query
that is based on that table still displays 10/1/2004. When I click on
Properties for that field in the query, format cell is not available.

KARL DEWEY said:
Have the data stored in the table in a dateTime field. in the form or report
have the format as you wish to see it.
This will display YourDateField in the format you want --
Format([YourDateField],"mmm-yyyy")

monia13 said:
I tried to convert text to date but it gave me 10/1/2004 vs Oct-2004. I want
to see Oct-2004 in my column heading.
Click to expand...
Click to expand...
 
The table format will not flow through to the query output.
Open the crosstab query in design view.
Expand the column that has your date field. Put the expression below in the
FIELD row for that column.
Expr1: Format([YourDateField],"mmm-yyyy")


monia13 said:
I was successful in formating the date in the table, but the cross tab query
that is based on that table still displays 10/1/2004. When I click on
Properties for that field in the query, format cell is not available.

KARL DEWEY said:
Have the data stored in the table in a dateTime field. in the form or report
have the format as you wish to see it.
This will display YourDateField in the format you want --
Format([YourDateField],"mmm-yyyy")

monia13 said:
I tried to convert text to date but it gave me 10/1/2004 vs Oct-2004. I want
to see Oct-2004 in my column heading.

:

Have you tried using a date field with format set for your display?

:

I have months - text data such as Oct-2004, Nov-2004, Dec-2004 that I want to
sort from in that order. I know you can customize the sort by using Orderby
commend, but I don't know where to input that commend.
Click to expand...
Click to expand...
Click to expand...
 
Expr1: Format([Appointment],"mmyyyy") & " " & Format([Appointment],"mmm -
yyyy")

monia13 said:
I was successful in formating the date in the table, but the cross tab query
that is based on that table still displays 10/1/2004. When I click on
Properties for that field in the query, format cell is not available.

KARL DEWEY said:
Have the data stored in the table in a dateTime field. in the form or report
have the format as you wish to see it.
This will display YourDateField in the format you want --
Format([YourDateField],"mmm-yyyy")

monia13 said:
I tried to convert text to date but it gave me 10/1/2004 vs Oct-2004. I want
to see Oct-2004 in my column heading.

:

Have you tried using a date field with format set for your display?

:

I have months - text data such as Oct-2004, Nov-2004, Dec-2004 that I want to
sort from in that order. I know you can customize the sort by using Orderby
commend, but I don't know where to input that commend.
Click to expand...
Click to expand...
Click to expand...
 
Back
Top