Data Report setting parameters of a child command

[maxflitom]

Dear Tek-Tips,

I am attepting to generate a report which lists all my employees and under them a detail of the Events and their Gratuties. I have Employee, Events, and Gratuity tables in MS Access and I am using the DataEnvironment for my conneciton. I want to set two parameters in the CHILD command which will filter by a range of dates in the Event table.

Output:
Employee 1
Function Name 35.25
Function Name 40.00
Employee 2
Function Name 2.25
Function Name 2.10

Command 1's CommandText
SELECT EmployeeID, LastName FROM Employees

Command 2's CommandText
SELECT Employee.EmployeeID, Events.EventName FROM (tables)
WHERE Events.EventDate BETWEEN ? AND ?

I can I set the parameters for the child command in my code to view the datareport?

Thank you for all your suggestions.

Tom

Tom (maxflitom)