Two charting questions

A

Alex

I have a field in my query [g_date] pulling dates from a table that are the
first day of the month; 8/1/04, 9/1/01, etc. The query is the source for my
chart. I have an unbound form containing textboxes that set the parameter
for the query. The chart works great until I make the format in the
underlying query: goaldate:format([g_date],"mmm/yy").

When I change the format, the chart axis lists a different set of dates than
the ones I've set in my unbound form. For example, If I ask for 9/1/04 -
8/1/05, the chart's axis lists 1/1/05 - 12/1/05. I'm showing the data table,
which does show the correct dates, but with the format 4-Sep, 4-Oct, etc....
Is there a way to change the date format from m/d/y to mmm/yy?

Also, I'm trying to show percentages in the data table. In my query I have
the column expressions as Goal:[goalname]/100 and then I have the format set
to percentage in the query. The query results show percentages perfectly.
The chart datatable, however, still shows 0.9173967, etc... If I change the
number format in the chart datasheet, it looks fine, buy only until I close
and reopen the chart again. Is there a way to set the number formats to
percentatges in the datatable?

Thanks so much
 
A

Alex

I used format([goalname],".00%") to accomplish my second question, but I'm
still struggling with the first. Thanks.
 
Top