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)
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)
