Hope you found your answer by now. Either way, I recommend adding a column in the query to calculate the percentage that you desire, then add that column to the report.
good luck Regards, Mark >From: allykatt04 <[EMAIL PROTECTED]> >Reply-To: [email protected] >To: [email protected] >Subject: [Access VBA Central] graphs based on report text boxes? >Date: Fri, 29 Jun 2007 13:21:28 -0000 > >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 > >
