MS Access Advanced report generation

The stuff around the chart can be done with subforms if one query can't bring it all together.  The form needs to be bound to something if you want the chart to change.  For example, if you want to show customer activity, the form should be bound to the customer table/query and the chart should be bound to whatever details you want to show.  The master/child links will keep the form and subform sync'd.

Upload a sample database.
Tell us how would you go about that if you have to do it manually.

Example: this database contains 3 tables a(f1, …), b(f1, …), c(f1, …), form f1, report r1
Chart to be on form f1 or report r1.
The chart data comes from table/query ….
the other info come from tables/queries ...

Hi @hnasr,

Thank you for asking for clarification.

For Example:- I have the following query

SELECT CREAT.Subject, CREAT.CREAT, CREAT.TargetDays, DISCHARGE.ADMINDT, DISCHARGE.DISDT, (SELECT LB_CHEM.CREAT FROM LB_CHEM WHERE LB_CHEM.Subject =CREAT.Subject AND LB_CHEM.InstanceName LIKE 'Screening') AS LB_CHEM_CREAT, SOFA.VASO, URINEOUT.URML/(SELECT VITALS.WEIGHT FROM VITALS WHERE VITALS.Subject =CREAT.Subject AND VITALS.InstanceName LIKE 'Screening') AS URINEOUTValue
FROM CREAT, DISCHARGE, SOFA, URINEOUT
WHERE CREAT.Subject = DISCHARGE.Subject AND
CREAT.Subject = SOFA.Subject AND
CREAT.Subject = URINEOUT.Subject AND
CREAT.Subject = ([Reports]![TestReport]![Subject])
ORDER BY CREAT.TargetDays;

From this CREAT.TargetDays is going to be x-axis values.
One Line series, Y-axis is CREAT.CREAT
Another Line Series, Y-axis is URINEOUTValue
Another Line Series, Y-axis is LB_CHEM_CREAT
Another is a horizontal line, X-Axis values are SOFA.VASO
Another is a vertical line, X-axis value is DISCHARGE.DISDT

Any help on how to generate this chart is highly appreciable. Please kindly help. Thank you.

To add a useful help in solving the issue, a sample database is needed.
This may invite more experts to help.