Database Design question

[101287]

I have to design a database that will contain all Months (Jan, Feb, March, etc). Each month will have specific information regarding monthly budget. How can I structure the database base so that I can query and get all the twelve months.

Suggestions welcome.

 

[fneily]

There must be more to it then what you presented. Because if that's all there is, then just use Excel. Then using some VBA coding, you can automatically create spreadsheets for the months, already formatted plus a summary sheet for yearly totals.

Why are you usting Access?

 

[101287]

Excellent feedback. Because the requirement is to generate the excel spreadsheet and added to an existing access report. There are two hundred projects and need to put together 200 graphs showing the monthly trend.

I'm able to create the access database base but not able to get one graph for each project. I'm getting twelve graphs. Therefore would like to retrieve one graph instead of the twelve.

I'm sure that If I'm able to setup the database and/or the relationship I will be able to retrieve just only one graph. But don't know how to accomplish this.

Guidance will be helpful.

Luis