T
thoron
I have created a form with a line plot. The numerical data for the plot is
stored in rows (across fields) in a table in the database; each row
corresponds to a different record. Because Access does not allow decimal
field names, I named the fields consecutive integers (1 - 74). I placed the
actual field names (x-axis labels) in a different table.
How do I modify the chart to replace the field names (the integers) with the
actual x-axis labels? I tried editing the datasheet for the chart, but those
changes are temporary because the data is replaced with data from the
rowsource table. Is there a way to change the x-axis labels? I cannot
change them in the query (i.e. SELECT tabel.* AS "8.00") because the labels
are decimals. Thanks!
stored in rows (across fields) in a table in the database; each row
corresponds to a different record. Because Access does not allow decimal
field names, I named the fields consecutive integers (1 - 74). I placed the
actual field names (x-axis labels) in a different table.
How do I modify the chart to replace the field names (the integers) with the
actual x-axis labels? I tried editing the datasheet for the chart, but those
changes are temporary because the data is replaced with data from the
rowsource table. Is there a way to change the x-axis labels? I cannot
change them in the query (i.e. SELECT tabel.* AS "8.00") because the labels
are decimals. Thanks!