S
Sue
Hi All.
I have a report which is run via DoCmd with a where
condition sent from a QBF form. Basically the query
selects individual people based on user criteria and gets
their ages and places them in a 10 year age group.
It I add a group section on Age Group to look at the data
being returned, it is correct.
However, the graph (in the report footer) based off of a
SQL statment for the same query always includes ALL of
the data. The SQL statement basically just groups the
data to Age Group and Count.
How can I pass my where clause to the SQL statement that
is the rowsource of the chart?
Thanks if advance. This is making me crazy!
I have a report which is run via DoCmd with a where
condition sent from a QBF form. Basically the query
selects individual people based on user criteria and gets
their ages and places them in a 10 year age group.
It I add a group section on Age Group to look at the data
being returned, it is correct.
However, the graph (in the report footer) based off of a
SQL statment for the same query always includes ALL of
the data. The SQL statement basically just groups the
data to Age Group and Count.
How can I pass my where clause to the SQL statement that
is the rowsource of the chart?
Thanks if advance. This is making me crazy!