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

  • Thread starter Thread starter Kay
  • Start date Start date
K

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
 
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?
Click to expand...

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
 
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
Click to expand...

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

John W. Vinson [MVP]
 
Include both the date/time field and the formatted text string; sort on the
date, display the string.

John W. Vinson [MVP]
Click to expand...

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
 
Back
Top