A
Alex
I have query that is the data source for a chart. The
query has a column that was formatted in a previous query
using format([Date],"m/dd"). The query gives the correct
dates, for example 8/1, 8/16, etc., but the chart still
shows 8/1/2004, which is the original format in the
table. And, the data table in my chart shows 1-Aug. This
is so frustrating. Any idea how I can fix this?
Thanks so much,
Alex
query has a column that was formatted in a previous query
using format([Date],"m/dd"). The query gives the correct
dates, for example 8/1, 8/16, etc., but the chart still
shows 8/1/2004, which is the original format in the
table. And, the data table in my chart shows 1-Aug. This
is so frustrating. Any idea how I can fix this?
Thanks so much,
Alex