Is is possible to either set parameters of a child command or set the .CommandText of a child command. I am attempting to generate a DataReport using Access 2000. I wish to list my employees (from the Employees table) and have their Gratuties (Gratuty table) listed (grouped) under them sorted by the EventDate field in the Events table.
I want to set the the .CommandText for the child command to something like this:
SELECT fields) FROM Gratuities INNER JOIN Events ON Events.EventID=Gratuties.EventID WHERE Events.EventDate BETWEEN ? AND ?
The results should look like this.
First Employee Name
Event One 02/06/04 5.00
Event Two 02/06/04 10.00
Second Employee Name
Event One 02/06/04 5.00
Event Two 02/06/04 10.00
Any suggestions?
Tom (maxflitom)
I want to set the the .CommandText for the child command to something like this:
SELECT fields) FROM Gratuities INNER JOIN Events ON Events.EventID=Gratuties.EventID WHERE Events.EventDate BETWEEN ? AND ?
The results should look like this.
First Employee Name
Event One 02/06/04 5.00
Event Two 02/06/04 10.00
Second Employee Name
Event One 02/06/04 5.00
Event Two 02/06/04 10.00
Any suggestions?
Tom (maxflitom)
