"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

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

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


.