Criteria behind a graph (chart)

[Laurel]

I have a graph (chart) in a form which has three unbound
controls, Student_ID, Start_Date and End_Date. I would
like to limit the data in the graph to dates between the
values of the Start_Date and End_Date controls, but I
can't figure out how to do this, as Linking Fields seem to
only handle equalities, not > <, etc., and I can't use
references to the form in the graph's RowSource because
Microsoft Graph spits it back. This seems like it would
be a fairly common thing one would want to do?
I haven't tried putting parameters in the underlying query
(the one used to build the chart) because I think that
would be a very bad solution from a user interface
perspective (assuming it would work....)

 

[Ben]

If you use the query from only one form you can get away with
referencing the controls on your form in the query, users will be none
the wiser. So your criteria for the query would become (might have to
play with the syntax a little, the .s might be !):

[frmMyForm].[Start_date] and <[frmMyForm].[End_Date]

HTH
Ben

 

[lAUREL]

When I put references to the form in either the underlying
query (recordsource) or the chart rowsource I get a
message that MicroSoft Graph doesn't recognize it.

-----Original Message-----
If you use the query from only one form you can get away with
referencing the controls on your form in the query, users will be none
the wiser. So your criteria for the query would become (might have to
play with the syntax a little, the .s might be !):

[frmMyForm].[Start_date] and <[frmMyForm].[End_Date]

HTH
Ben

I have a graph (chart) in a form which has three unbound
controls, Student_ID, Start_Date and End_Date. I would
like to limit the data in the graph to dates between the
values of the Start_Date and End_Date controls, but I
can't figure out how to do this, as Linking Fields seem to
only handle equalities, not > <, etc., and I can't use
references to the form in the graph's RowSource because
Microsoft Graph spits it back. This seems like it would
be a fairly common thing one would want to do?
I haven't tried putting parameters in the underlying query
(the one used to build the chart) because I think that
would be a very bad solution from a user interface
perspective (assuming it would work....)

.

 

[Van T. Dinh]

See the thread "Charts" in the newsgroup "microsoft.public.access.forms"
started by Tiffany <[email protected]> on 17 November 2003 05:15 (my
date/time, GMT + 11:00).

 

[Laurel]

Thanks. This looks like just what I need....bottom line -
I needed verification that the trouble I was having was
because of Access, not because of my newcomer status.

Thanks again!

-----Original Message-----
See the thread "Charts" in the

newsgroup "microsoft.public.access.forms"