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 Wanet Telecoms Ltd 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. fender78

    ODBC - Access Pass Through Query Issue

    Thanks. I tried it out and it works perfect. Thanks for your help.
  2. fender78

    ODBC - Access Pass Through Query Issue

    I've created a ODBC connection to a network server. Then it opens the Pass Through Query window. From here what kind of coding am I required to use. Is there a browse feature available to grab tables from the server. I work with Witness Monitoring Systems and am currently logging into the server...
  3. fender78

    Linking different named fields?

    I'm logging into to the server direct and using tables from it. I wsa previously using a MS database, but I'm trying to get around that now.
  4. fender78

    Linking different named fields?

    Yes, How do I go about doing a union query? Thanks for your help.
  5. fender78

    Linking different named fields?

    I am building a report via a ODBC connect to a Witness Systems Server. I am currently using 40 data tables. A few of the fields, contain the same data, but the field is named differently. Trying to link fields together. example: (MyTable1.AccountNum123) (MyTable1.AccountNum231)...
  6. fender78

    Auto Refreshing Cystal Reports

    Yes, I have over 50 crystal reports that are done daily and I am having to refresh each one manually. I just want them to refresh automatically without me having to hit the lighting bolt for each one. Thanks, Jim Ellis
  7. fender78

    Auto Refreshing Cystal Reports

    Hello, I was wondering if there was a way to have the crystal reports automatically refresh when my database is updated. I took off the "Save Data With Report" option off, but this causes the report to open in design view instead of preview. Thanks in advance. Jim L. Ellis
  8. fender78

    Grouing Horizontally

    Hello, I was trying to group horizontally in crystal, but I am getting confused. Basically this is what I am trying to do. Group #1 Group #2 Group #3 Field 1 Field 2 Field 1 Field 2 Field 1 Field 2 Currently the only way I can do this is vertically and I need Month to...
  9. fender78

    I'm trying to convert a date field that is text into a date/time field

    I work for a davox dialer team ,the reporting aplication gives me date as "Tues October 4, 2002" I would like to change this to 10/04/2002. Thanks in advance. Jim L. Ellis
  10. fender78

    Summing text fields

    If I had time in text format, how would I go about summing these feilds? Thanks, Jim
  11. fender78

    Time conversion and formatting.

    How would I go about summing the fields since their text objects now. Thanks, Jim
  12. fender78

    Time conversion and formatting.

    Thank you very much, I pasted your formula right in and it was amazing. Thanks again, Jim A well deserved Star.
  13. fender78

    Time conversion and formatting.

    I am trying to convert time which is in seconds to a hh:mm:ss format. I work on a davox dialer team and the time is exported in seconds through their reporting applications. I've made several attempts and am still unsuccessful. I tried using a string quote, but not real good at those. Thanks...

Part and Inventory Search

Back
Top