How do I sort on a date field that has been formatted too mmm yyyy?

[Kay]

Hi
I use Access2002, I have a table with dates which I would like to
graph - Problem is I want to group the data fro the graph by mmm yyyy.
When I view the graph the order is incorrect as the format function
has converted the field to text. Is there a way to preserve the date
order on my mmm yyyy field?
Thanks
KayC

 

[Scott McDaniel]

Hi
I use Access2002, I have a table with dates which I would like to
graph - Problem is I want to group the data fro the graph by mmm yyyy.
When I view the graph the order is incorrect as the format function
has converted the field to text. Is there a way to preserve the date
order on my mmm yyyy field?

I don't use Graphs often, but can you base the graph on a query? If so, you can then sort that query and (hopefully) the
graph will then sort properly ...

Scott McDaniel
scott@takemeout_infotrakker.com
www.infotrakker.com

 

[John W. Vinson]

Hi
I use Access2002, I have a table with dates which I would like to
graph - Problem is I want to group the data fro the graph by mmm yyyy.
When I view the graph the order is incorrect as the format function
has converted the field to text. Is there a way to preserve the date
order on my mmm yyyy field?
Thanks
KayC

Include both the date/time field and the formatted text string; sort on the
date, display the string.

John W. Vinson [MVP]

 

[Kay]

Include both the date/time field and the formatted text string; sort on the
date, display the string.

John W. Vinson [MVP]

Thanks for your tips guys, the dataset I have is a select query which
is grouped by the MMM YYYY field, I tried bringing the original date
field in but it messed up my aggregation so I MAXED this field on the
aggregation and it worked.
Thanks, KayC