If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Creating Reports from Forms
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 |
#2
|
|||
|
|||
The query by form sample download at
http://www.rogersaccesslibrary.com/O...p#Hookom,Duane allows users to select any fields from master queries (which you create once). They can sort and group and filter. Results can be sent to CSV, Print, Html, Word, Excel, or Graph. -- Duane Hookom MS Access MVP -- "tbd" wrote in message ... 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 |
#3
|
|||
|
|||
Brilliant, thank you very much Duane!
-----Original Message----- The query by form sample download at http://www.rogersaccesslibrary.com/O...aries.asp#Hook om,Duane allows users to select any fields from master queries (which you create once). They can sort and group and filter. Results can be sent to CSV, Print, Html, Word, Excel, or Graph. -- Duane Hookom MS Access MVP -- "tbd" wrote in message ... 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 . |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Images in Forms and Reports | MortOnSafari | Using Forms | 2 | August 2nd, 2004 07:48 PM |
Reports and Forms | Cynthia | Using Forms | 4 | July 12th, 2004 07:12 PM |
Creating Reports from Tables and Queries | Moonman | Setting Up & Running Reports | 1 | May 27th, 2004 03:32 PM |
Creating Headers/Footers in Reports | Nouman | Setting Up & Running Reports | 1 | May 20th, 2004 04:00 PM |