I have a query which returns me three values - Symbol / Close Date / Close. In my query I request the symbol ([Enter Symbol]) and the number of days (Between Date() and Date-[Enter Days]) In the form chart -- Setting Axis (Close Date(day)), Legend (Symbol), Values (Close (Sum))
Access returns "... does not recognize "[Enter Symbol]" as a valid field name or expression
If I set the legend to none it works but no legend is shown. If I stipulate the symbol in the query it works fine if the legend is set to symbol.
Does anyone have any idea how to get the symbol to show up on the chart.
Just an aside I am suprised that "Modern Charts" does not support grids - trying to resolve getting a grid and trying to get the symbol on the chart has cost me several hours of effort; for what I believe is a very simple and common report.
