I have encountered a problem while working on crystal reports.I have a sample table with the following data

 

TID	Date	Item
T100	8/1/2010	Laptop
T100	8/1/2010	Desktop
T101	8/1/2010	Laptop
T102	8/1/2010	Desktop
T103	8/2/2010	Laptop
T103	8/2/2010	Desktop
T104	8/2/2010	Laptop

 

I need the data when a person bought laptop & desktop on the sameday i,e the rows that are in green only .I used a formula in the record select but its not working,it is returning no rows.Can any one please help me to resolve this issue ?

 

Formula :

table.date in date() to date() and table.item = "laptop" and table.item = "Desktop"

 

Thanks

 

All I need is only when a person bought both " laptop and desktop "