Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. RichieRich99

    SQL Statement: Seems Easy but isn't: Use IN?

    No worries. I actually got it to work a couple of minutes after I posted. Just doing extensive testing now. Here it is for those interested: select * from cfprddta.cd1 where cdcode = 'MINF04' AND memberid IN ( select memberid from cfprddta.cd1 where (cdcode =...
  2. RichieRich99

    SQL Statement: Seems Easy but isn't: Use IN?

    Hi all, I was asked for this query and thought it would be easy but I've struggled with it for more that two hours now. For simplicity purposes, I have the following table: Table: CD Member ID, Code, Date 100, MINF03, 03/30/2005 101, MINF04, 03/30/2005 102, MINF04, 03/30/2005 102, MINF05...
  3. RichieRich99

    Indexing Not Showing up in CR 8.5? Perplexed!!!

    Hi all, I am recreating some reports using Crystal Reports 8.5 and connecting to some DBase tables (.DBF). These tables already have indexes created for them (.cdx) but when using the Visual Linking "Expert" all options to use indexing or to create indexes is grayed out / disabled. I've...

Part and Inventory Search

Back
Top