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 sizbut 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. robertsdgm

    Perl and Apache Log search?

    Hello All It has been quite a long time since I have used perl.. I have a huge apache access log and from this I need to print out all the unique IP address's and their access time. How do I go about doing this if my general line output is such as below?! Thanks Dan cbdw88209.utp.test.dan.com -...
  2. robertsdgm

    update tables?

    What I have done..is imported from Excel a worksheet named "dan" Then from here within Access I ran analyze table on "dan" and in turn broke up the orginal "dan" table into dan1,dan2 and dan3 tables within access with relationships btw these last three tables. Now at this point access renames...
  3. robertsdgm

    update tables?

    I have one large table from Excel which I "imported" into Access. Thereupon, I then I ran analyze table on this "large" table and broke it all up into a true RDBMS. My question is.. Now I have made updates to this large Excel table. How do inturn update all the subsequent little tables...
  4. robertsdgm

    Help with a where clause in access query

    Thks! and how about if my query returns a null value for a particular attribute for a given record..how would I print the word "unavailable" for instance? thks! Dan
  5. robertsdgm

    Help with a where clause in access query

    Hello All How do I go about in access creating a where clause or using LIKE or something similar? I have an access query that works just fine and returns 200 records. But now I want to further qualify by adding a where clause or using like and finding all the first names with or like DAN and...
  6. robertsdgm

    Coloring results in a report?

    Hello All Is there a way to color the results in a given report based on where the value happened to come from.. In other words..my query gathers data from two tables. In the report I want the values from the first table to be in black..and those values from the second table to be in blue. thks Dan
  7. robertsdgm

    Counting records and displaying line numbers in a report?

    Thanks...got the COUNT(*) to work.. And how would I individually number each line in my report as well? Dan
  8. robertsdgm

    Counting records and displaying line numbers in a report?

    Hello I would like to have in my report footer a count(*) of the total number of records in a multi-page report. How do I do this in the footer of a report? If I use count(*) it doesn't know what to count and if I drag the text box to the detail section, then that works but I get the count(*)...

Part and Inventory Search

Back
Top