Creating Reports from Forms

  • Thread starter Thread starter tbd
  • Start date Start date
T

tbd

Hi! I am trying to create a form that will create new
reports on an ad hoc basis. Basically, I have one large
Query that contains Volume figures for a number of my
products. What I would like to do is create a chart from
these figures. The problems lies in that as the products
are constantly changing, I can not create the Chart
reports now and then call them up from a button.

Is there anyway that I could have a "Create Chart" button
on my form, which would allow me or the user to select
from a number of options the Values I want to see on the X
and Y axes? For Instance, at the moment the base query is
laid out as thus:

Product May Volume June Volume July Volume
CD123 12 10 0
CD124 12 10 0
CD125 5 5 5
MD111 1 0 0
MD112 0 0 0

I would like the form to contain drop-down menus of the
Product options, then another with the Monthly volumes, so
that I could for example select Product CD123, and then
June and July Volumes, and then press a button that will
create a chart displaying the relevant information that I
have requested, and not all the information that lies in
the query. Is this even possible?

tbd
 
Back
Top