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 gkittelson 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. alljax

    Contact Management Database

    I have a simple Contact Management Database that I have modified. I am using this to manage mailings and calls. I have created a table called 'Letters' I have set a relationship between the letters and contacts as one to many, using the contact id as my primary key.(One contact can have multiple...
  2. alljax

    Need To Sort Records By Two Feilds

    I am currently counting multiple values in the same field and sorting by SiteID # (SitID), but I would like to also sort by month. How can I do this? Example: Date --------------- January February March April Etc. I want to be able to sort by Site ID (SitID) and month. Current script that...
  3. alljax

    Count Property-Multiple Values in Same Field Not Working

    Never mind, I figured it out. ~ Chris
  4. alljax

    Count Property-Multiple Values in Same Field Not Working

    Simon, Thank you so much you really saved me. Please let me know where I can send a check because you deserve to have some compensation. The last question I have is how to make it so that a dealer can enter his site ID into a form and have that submit to the asp page and bring up the...
  5. alljax

    Count Property-Multiple Values in Same Field Not Working

    Yes, I want to output the results in a table. However I am still geting nothing. It just reads (Report for site ID &quot;CY2KFC&quot;), but nothing else. Here is the full code: <html> <head> <meta HTTP-EQUIV=&quot;Content-Type&quot; CONTENT=&quot;text/html;charset=windows-1252&quot;>...
  6. alljax

    Count Property-Multiple Values in Same Field Not Working

    This seems to work: sql = &quot;SELECT FinLog.AppSta, Count(FinLog.SitID) AS Records FROM FinLog GROUP BY FinLog.AppSta, FinLog.SitID HAVING (((FinLog.SitID)='CY2KFC')) ORDER BY FinLog.AppSta DESC&quot; The good thing is that I no longer have errors, the bad part is that I must not be...
  7. alljax

    Count Property-Multiple Values in Same Field Not Working

    I think we are on the right track. Now I come up with this error, but it has nothing to do with your SQL statement, I think. Here is the error:Error Type: Microsoft OLE DB Provider for ODBC Drivers (0x80040E10) [Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 2...
  8. alljax

    Count Property-Multiple Values in Same Field Not Working

    I still get this error: Error Type: Microsoft VBScript compilation (0x800A0401) Expected end of statement /please.asp, line 23, column 135 sql = &quot;SELECT FinLog.AppSta, Count(FinLog.SitID) AS Records FROM FinLog GROUP BY FinLog.AppSta, FinLog.SitID HAVING...
  9. alljax

    Count Property-Multiple Values in Same Field Not Working

    Simon, Thanks for the help, unfortunately its not working for me. I think that maybe there is something wrong with my script. Here is my entire script. I am pulling from a database named “ONLAPPCYC2K” and the table is “FinLog”. ~ Chris <html> <head> <meta...
  10. alljax

    Count Property-Multiple Values in Same Field Not Working

    I need to count different values from the same field and have them print out four separate counts. I also need to be able to sort these by Site ID. Here is how my data looks: X SiteID ---------------- --------------------- 3 35012 3 12345 3 35012 1 35012 1 35012 3...

Part and Inventory Search

Back
Top