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
|
|||
|
|||
"Nurture" the graph
I have monthly data in queries. One query to each month.
In form, trough combobox, I need to choose the monthly=20 query to "nurture" the graph in subform. I would like help, because I don=B4t know the best way to do=20 this. (And I never saw any sample) Any idea is welcome. Sev |
#2
|
|||
|
|||
Sev,
To begin with, it looks like you have started off with a poor design; a separate queruy for each month shouldn't be necessary, you should have one query with a month filter. Now, getting to the particular question: once you have changed your design to a single query, "feed" the graph from it, and make the month criterion in the query read directly from the combo on the form (Forms![FormName]![ComboName]), and the job is done. HTH, Nikos "Sev" wrote in message ... I have monthly data in queries. One query to each month. In form, trough combobox, I need to choose the monthly query to "nurture" the graph in subform. I would like help, because I donīt know the best way to do this. (And I never saw any sample) Any idea is welcome. Sev |
#3
|
|||
|
|||
Thanks for your replay.
I need to have Crosstab queries to calc values and I think=20 isn't possible to filter the Date. Therefore, I have one query for month and I have in Date=20 Column: Between (#01/02/2001#) And (#28/02/2001#) I don't know solution for this... Thanks. Sev -----Original Message----- Sev, To begin with, it looks like you have started off with a=20 poor design; a separate queruy for each month shouldn't be necessary,=20 you should have one query with a month filter. Now, getting to the particular question: once you have=20 changed your design to a single query, "feed" the graph from it, and make the=20 month criterion in the query read directly from the combo on the form (Forms![FormName]![ComboName]), and the job is done. HTH, Nikos "Sev" wrote in=20 message ... I have monthly data in queries. One query to each month. In form, trough combobox, I need to choose the monthly query to "nurture" the graph in subform. I would like help, because I don=B4t know the best way to do this. (And I never saw any sample) Any idea is welcome. Sev . |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Graph and Charts | Kart18 | General Discussion | 0 | October 19th, 2004 04:39 PM |
Excdel graph | Pat | Worksheet Functions | 0 | August 21st, 2004 07:14 PM |
Creating a Graph in a report... | Setting Up & Running Reports | 2 | May 26th, 2004 05:21 PM | |
Column + Scatter Graph | Adapted | Charts and Charting | 5 | January 15th, 2004 02:56 PM |
Dynamically control how many lines on a graph? | Keith R | Charts and Charting | 2 | October 22nd, 2003 04:19 PM |