You may have already found the answers to your problems, if not however there are several ways around your problem.
Maybe the easiest would be to make the query which forms your access report into a make table query. Then use ms query in excel to import the table you have just made instead of importing the access query. Another method would be to remove the User Prompt from your query within access and instead set up parameter fields in excel, this would the create the same results as what your original access query gave you. Hope this helps, if you need more details please just let me know. Regards Ritchie --- In [email protected], allykatt04 <[EMAIL PROTECTED]> wrote: > > 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 >
