Hi all,

I am inputting the customer details on arrival basis to the database.

I've placed TWO DTpicker controls on the form, & wud like to print the customer report between 2 different dates.

Your help is highly appreciated.

Thanks

Hi

Can you give us a bit more info please.

Are you using crystal, data reports or your own code.

Are you using a data control or a reference

Whats your db please Access / SQL Server or other.

Cheers Steve

Hi Steve,

I am using Data report, Data Enviroment with DB SQL Server.

Hope you can help me with the above info.

Thanks in advance.




quote]steve_w wrote:
Hi

Can you give us a bit more info please.

Are you using crystal, data reports or your own code.

Are you using a data control or a reference

Whats your db please Access / SQL Server or other.

Cheers Steve

Hi

I set up a dataenvironment and datareport to use an sql command in the designer.


Then at run time modify the sql command as below

Private Sub Command1_Click()     DataEnvironment1.Commands(1).CommandText = "select * from tablename where date = '" & DTPicker1 & "'"     DataEnvironment1.rsCommand1.Open          DataReport1.Show 1     DataEnvironment1.rsCommand1.Close End Sub

I chose to equal the date but you could have
where date >= '" & dtpicker1 & "' and date < '" & dtpicker2 & "'"


Steve