Hello, I am a WPI student working on a database project for an internship. I have created a database in ms access 2000, and I am putting together some reports to display the data.
When the report opens, a macro loads to open a form and ask the user for a date range. The report is then filtered (because it is based on queries that need the user-entered form data) and returns only data within the range. Within the report, I need to include a custom bar/line (line for goal%, bar for actual%) graph based on sums and totals from text boxes in the report. I have NO idea how to do this. Access doesn't have the right graphs, and only lets you use 6 columns (i need 12- One for each month of a year with varying start months) I am guessing that I need to export the data into excel (which has the right graphs, and would display it properly) and then import the resulting graph back into access, but I am not sure how to do this or if it's even possible. Because the data is based on a user-entered date range, I can't figure out how to even link it into excel. (I keep getting a "Too Few Parameters. Expected 2." Error message from Microsoft Query.) I read something about TransferSpreadsheet Methods, but I am unsure if this is a solution to my problem and how/where/when to use them in the first place. Thank you for your time, ~Allison
