VBA Code or tip to Chart/Graph only one record of data

[cozinon]

Hi there,

If anyone could provide some coding, or tips to the following question it would be greatly appreciated. The version of MS Access I am using is 2003.

My goal is to create a line chart for data across one record. The data format is similar to:

Record contains Material Number, Demand 1, Demand 2, Demand 3, etc.

I'm fairly new to coding, and could use a kick start in this area.

Cheers,
CoZ

[Rabbit]

If what you're trying to chart is Demand #. That's not how charting works. You need to normalize your data first. There's no need for VBA code.