Filtering Graph at a Form based on Date Range!

[cap.zadi]

Hi

I have form "FrmGraph" where a chart is drawn via QryGraph" which has fields "CusID", "CusName", "Product", "SoldQty", "SalesDate",etc.

Its been very easy to control the graph with Customer name via the Combo Box "CboCustomer" by linking the Child & Parent fields but what could be the way out to filter the graph results according to the desired period.

Assume Date range fields are created via the Text boxes "TxtStartDate" and "TxtEndDate" at the same form.



Kindly advise the needful.

[cap.zadi]

The desired sample screen view is enclosed.

[June7]

I have never found the Master/Child Link properties of graph control useful. I build filter criteria into the graph SQL statement.
Such as: CustomerID = [cboCustomer] AND SalesDate BETWEEN [TxtStartDate] and [TxtEndDate]

However, I have never had to use a CROSSTAB query for any graphing. Post your graph SQL statement.

[cap.zadi]

Hi

Thanks for advise and its probably true.

SELECT QryDisplayResidueScreening.SampleDate, QryDisplayResidueScreening.[Residue%], QryDisplayResidueScreening.BCCode, QryDisplayResidueScreening.SampleLocationFROM QryDisplayResidueScreening;

The field to show only is "SampleDate" & "Reside%"

[June7]

Don't include fields in SELECT clause that are not needed for graph. Now try the WHERE clause as suggested.

Advise not to use punctuation/special characters (underscore only exception) in naming convention. Better would be ResiduePct.

[cap.zadi]

Hi
Well. I thought as i saw one video lecture in which he kept the customer Name as for the purpose of selection.

Anyways, its good idea and i will not keep those fields in the graph data.

It would be appreciated if can provide the SQL statement for the above selection criteria and data?

[June7]

I already suggested a WHERE clause criteria in post 3.

[cap.zadi]

Hi

I did not get the idea.

Kindly help with the code.

Regards

[June7]

Maybe:

SELECT QryDisplayResidueScreening.SampleDate, QryDisplayResidueScreening.[Residue%] FROM QryDisplay WHERE CustomerID = [cboCustomer] AND SalesDate BETWEEN [TxtStartDate] and [TxtEndDate];