Making Chart based on Query

[raabbasi]

One of the requirements of my project is that a report should print a Bar Chart, based on a query.
The related query has the following fields:

ItemCode, Quantity_received, Quantity_delivered, and the Date.

The report should depict the number of transactions over a period of time, chosen by the user.

I have programming knowledge in Visual Basic, but quite beginner in MS Access VBA.

Any help please!

 

[GingerR]

Hi there--is this a school project?

How far have you gotten? What's your query? You don't need to know VBA to make a chart. Do you have your form set up to get the date range from the user? Have you tried making a chart yet? If so, how is it not doing what you want it to do? Let us know how far you've gotten and we can help from there!

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[raabbasi]

Thanks GingerR for the response.

After submitting the request, I happend to know that this can be done using Microsoft Chart. So I did and got some output as well, though not to my satisfaction.

Please allow me some time to understand Microsoft Chart better and then I will be able to ask a better question.

My best regards.

 

[GingerR]

MS Graph within Access is harrowing at best. not much documentation to help you.

Try this to get started, to get rid of the North-South-East-West thing and see how your chart will really look: run your query that is the basis for the chart. hit ctrl+a (select ALL) then ctrl+c (copy). double-click the chart object, and view the DATASHEET. click in the upper-left square and hit ctrl+v(Paste). this will paste in your data (as a template) and you can see what your graph will look like for real. this helps you to change colors, chart type, etc. Hope that helps.

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244