maintain barchart colours everyday

[mahmad]

Hi,

I have a data access page which shows output on a daily basis with some
numbers on a chart. I have to change the barchart colours for a particular
group every morning. Is there a way to hardcode the barchart for a
particular field out of my access query. At the moment the query looks at
two fields, and output the data onto a ms access data chart.

Thanks
Mo