Making better reports

[Czeszyn]

I am not sure if this is even possible. I want to be able to take two separate queries to create a 2 line graph. Also to be able to spice the graphs up some. The ones I have done, single line, even seems dull. I would like to reports to look professional. I hope there is a way.
Thank you in advance.

 

[spikepl]

No one has any idea what "spice up" or "look professional" means in your mind. If you want something then provide information or examples that make it possible for people to understand what you want, in terms of what you have and what you wish to have.

 

[Czeszyn]

Spice up means, to make it look better than just the basic one line graphs. I want to be able to put more than one line on a line graph like you do in excel. Is there away of doing this.

 

[GinaWhipp]

Well, since the graphing in Access hasn't changed in years, I send my data out to Excel and use Excel's graphs. Never was worth the time involved to make Access Charts look decent.

 

[Czeszyn]

If i go that route, can you walk me through. Will I be able to set up my reports in excel, and each time in access when i enter my dates to bring up my data, will it change each time in excel? Not sure how this part works.

 

[GinaWhipp]

Just set up your Chart on Sheet1, on Sheet2 put your data and link your Chart to it. For the purpose of testing use some dummy data on Sheet2 so you can get your Chart the way you want.

Then, export your data to the Workbook-Sheet2 and open the Workbook.

 

[Czeszyn]

Would that let me keep that worksheet, so that each time i request different dates it would print the data in the excel, or will i have to always send it there.

 

[GinaWhipp]

I don't understand... keep the Worksheet. You are creating a Workbook and sending data to an existing Workbook why wouldn't it save?