Date Parameter for 2 subreports and 1 source query

[summer01]

I have created 2 separate Chart reports from a single query and did not show any date parameters. I placed them both on a report that is not bound to a query. I have been looking on the internet and have tried a several different things, but they are not working. The following link gives great info but does not work in my situation and I keep getting invalid braketing errors.

http://bytes.com/forum/thread205610.html

I have tried unbound text boxes for begin and end dates and that is not working. I put a date parameter on my source query for the charts and it ends up giving me pages and pages of the same chart. Below is the sql of my source query: Any ideas you might have will help.

SELECT tblPhoneCalls.[Supp ID], tblPhoneCalls.[Type Of Call], tblPhoneCalls.[Reason For Call], tblPhoneCalls.[Line Of Business], tblPhoneCalls.Comments, tblPhoneCalls.ResourceUsed, tblPhoneCalls.[Date Entered]
FROM tblPhoneCalls;

 

[JBinQLD]

Have you tried:

SELECT tblPhoneCalls.[Supp ID], tblPhoneCalls.[Type Of Call], tblPhoneCalls.[Reason For Call], tblPhoneCalls.[Line Of Business], tblPhoneCalls.Comments, tblPhoneCalls.ResourceUsed, tblPhoneCalls.[Date Entered]
FROM tblPhoneCalls[red]
WHERE tblPhoneCalls.[Date Entered]) Between forms!frmMyForm!txtFromDate AND forms!frmMyForm!txtToDate;[/red]

?

JB