Data Environment Setting Parameter Help 1

[maxflitom]

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)

 

[xbafge]

Try it.

 

[zyrag]

In your DataEnvirnment, try

PARAMETERS pDateFrom DATETIME, pDateTo DATETIME;
SELECT fields) FROM Gratuities INNER JOIN Events ON Events.EventID=Gratuties.EventID WHERE Events.EventDate BETWEEN pDateFrom AND pDateTo

 

[BobRodes]

zyrag's should work, but you can just do this:

myDE.MyConnection.MyParentCommand.MyChildCommand.CommandText = "SELECT fields) FROM Gratuities INNER JOIN Events ON Events.EventID=Gratuties.EventID WHERE Events.EventDate BETWEEN (" & Variable1 & " AND " & Variable2 & &quot"

Where variable1 and variable2 are the dates, say gotten from text boxes or whatever.

HTH

Bob Rodes