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 Rhinorhino 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. CrystalChris

    Count Distinct (Per day) IP Addresses for a date range

    Hi, I am looking for some help to create a mysql query to get the distinct (per day) count of ip addresses a link has been clicked for a date range. Lets say my IP address clicks on the same link 5 times every day during January 2012 using the same ip address. There would be 155 (5*31) records...
  2. CrystalChris

    Slow Performing Report

    Below is the final solution: SELECT CPINFO.REFVAL, CPINFO.ADDRESS, CPINFO.EHAREATM, CPINFO.TRADEAS, XIREC.REFVAL as REFVAL2, XIVISIT.XIVTYPE, XIVISIT.DATEVISIT, XIVISIT.VOFF, XIACTION.XIACT, CNOFFICER.NAME FROM (((CPINFO INNER JOIN XIREC ON CPINFO.KEYVAL = XIREC.MDKEYVAL) INNER...
  3. CrystalChris

    Slow Performing Report

    Thanks for both your input on this. I've tried the minus command. However, it brings back records that have a letter type (XIACTION.XIACT='LETT1'). I managed to resolve the problem by using the NOT IN command. Thanks Chris
  4. CrystalChris

    Slow Performing Report

    Hi, I've developed a report in Crystal Reports XI which will list the records in Command 1 which are not in Command 2. The problem that I'm facing is the report takes forever to load. However, if I do the same query in Microsoft Access it loads within 10 seconds. Command 1 SELECT...

Part and Inventory Search

Back
Top