Sample Data Problem

[Guest]

Hello,

I'm creating a report based on a query, pulling date and two currency fields.

My problem is that even if I save, etc., when I go into the design of the
chart, it always shows the sample data. This means that the x axis where I
want to display the date cannot be formatted as I wish. If I select date, it
tries to format the word North from the sample data. It simply reverts to
general and instead of displaying my dates property, ex., 01/02/06, is shows
the week number and year.

I am using Access 2002 with a database from Access 2000. (I need to keep
2000 format)

Thanks!

 

[fredg]

Hello,

I'm creating a report based on a query, pulling date and two currency fields.

My problem is that even if I save, etc., when I go into the design of the
chart, it always shows the sample data. This means that the x axis where I
want to display the date cannot be formatted as I wish. If I select date, it
tries to format the word North from the sample data. It simply reverts to
general and instead of displaying my dates property, ex., 01/02/06, is shows
the week number and year.

I am using Access 2002 with a database from Access 2000. (I need to keep
2000 format)

Thanks!

Recreate the chart on a Form. After you get all the data showing
correctly, copy and paste the chart onto your report. It will then
show the correct data in the report in design view.

 

[Guest]

Thank you so much. Any idea why this happens?

Thanks again for your help.