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. steve99999

    Sub SELECT?

    Cheers Rudy !!! It works a treat and takes only 8 seconds :) Here is my version: SELECT id,ip,max(form) as form1 from jan2004 GROUP BY ip ORDER BY date Thanks again !!! Steve
  2. steve99999

    Sub SELECT?

    Hi, I have hot a table with 50,000 + rows of IP addresses ripped from apache logs. I need to SELECT DISTINCT the ip and check if the field 'form' is set to 1. if form is not =1 then still select eg. TABLE - IP form 169.168.0.1 0 169.168.0.1 0 169.168.0.1 1...
  3. steve99999

    Server has not yet been opened (Crystal report viewer control)

    I too was having this problem, but have just solved it using this command: Report.Database.Tables(1).SetLogOnInfo ODBC, , Username, Password In the def for this it says servername, but this needs to be the ODBC name(first parameter) thats what caught me out.

Part and Inventory Search

Back
Top