I'm using Access 97 becasue that is the corporate norm here. If 2000 will resolve this issue, I may be able to upgrade.
I'm trying to generate a report for vehicle operational data, number of hours and kms run per week, month etc.
I have a main report with a number of text fields, and that query is grouped on the vehicle number: "vehicle"
I have three charts for each vehicle, each based on a different query. The charts are usually correct, but seemingly at random, one of the charts will repeat, so the chart for vehicle 5 will also show up for vehicle 6... or the charts for vehicles 5, 6 and 7 will show up for 6, 7 and 8 etc. The chart queries also all have the vehicle number.
I have tried two different methods of linking the charts to the main report. I have put "vehicle" into each of the 'Link Master Fields" and "Link Child Fields" in the chart properties. I have also tried putting a where clause in the chart query (ie. where vehicle ChartQuery.vehicle = [Reports]![MainReport]![vehicle]). I then had to define [Reports]![MainReport]![vehicle] as a parameter of datatype text in the ChartQuery.
A few other pieces of info that might be relevent:
-The underlying tables are ODBC linked tables
-I have a number of sub-queries before getting to the queries that drive the charts.
Any help you can provide would be greatly appreciated.