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 Chriss Miller 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. victorthomas

    Internal email not routed error #5.1.1 only external works.

    I'm using an exchange server actually SBS 2003 and a 3rd party POP3 connector to get external e-mail and route to exchange. All external e-mail routing works however users of the exchange server CANNOT send e-mail messages among themselves or internally, if they do they get a: “User doesn’t...
  2. victorthomas

    POP3 receive mail interval

    I have run into this same issue before and the best way to get around it is to get a 3rd party POP3 connector, they are much more flexible than the MS POP3 connector. There is no registry hack that I am aware of. Victor Thomas
  3. victorthomas

    MS SQL 2000 UNION Limitation

    I have a union query which has perfect syntax and is a legal statement. SELECT ID, Name, Company, Fax1, Notes FROM dbo.right_fax_unified_phonebook WHERE (Fax1 IS NOT NULL) UNION SELECT ID, Name, Company, Fax2, Notes FROM dbo.right_fax_unified_phonebook1 WHERE...
  4. victorthomas

    Merging Columns in a table

    Thanks Angel, sorry about the late reply I'm also an admin and all hell broke loose on my network took a while to get a couple of minutes to get back to this SQL project. I really appreciate your reply! I'll give a shot and let you know the results. Victor Thomas
  5. victorthomas

    Merging Columns in a table

    I have a need to merge data columns in a table. I'm using rightfax and I need to merge data in a FAX column and in an E-MAIL column both columns are text columns. Here is an example from table tbl.Customers: INITIAL TABLE CONTENT: NAME FAX E-MAIL ----- ---------...
  6. victorthomas

    Conditional charting

    My Client is adamant that I don't use a "-99999" or some other such identifier hence my dilema. I did some CR KB surfing and found c2005689 http://support.crystaldecisions.com/library/kbase/articles/c2005689.asp and of this code I did a spin off of sorts: if Maximum ({@Oswestry...
  7. victorthomas

    Conditional charting

    Happy Holidays everyone! I need some help! I have to chart off numerical data in a database. For the x-axis there are 3 different possible sets of data that can be &quot;pulled&quot; out of the database. Data Sets --------- 1. Numerical value <> 0 2. Numerical value = 0 3. <NULL> Data Set #1...
  8. victorthomas

    Text summary operation

    Thanks for the reply! I misstated the original question. The summary field GUI does work but it seems unable to tell the difference between the strings &quot;thomas&quot; and &quot;THOMAS&quot; using the maximum and minimum group summary operators. So the summary operator only returns...
  9. victorthomas

    Text summary operation

    Here is my issue: In the details section I have a bunch of last names displayed, some lastnames have been displayed as all caps ucase() or all lowercase lcase() based on a certain if...then condition. An example result set in the details section looks like this: THOMAS THOMAS thomas THOMAS...
  10. victorthomas

    MetaData Database reporting!

    Thanks for your help! I solved the problem this morning by generating a view in SQl 2000 that bypassed the problem of having to report multiple times from the same field! I then used crystal to group of the view! Whew! huge headache solved did not have to rebuild entire report! Thanks again...
  11. victorthomas

    MetaData Database reporting!

    Thanks for the reply!! I'm running crystal version 9.0 The data I want to group on is medical data and is stored in a 7800 text field {answers.answerstext} Data formatting and integrity is performed by an applicaion called DocuMed 2000. In this case the data woulde look like: Allan, Boyum, M.D.
  12. victorthomas

    MetaData Database reporting!

    I'm reporting of a metadata database, this is a very unique database design (see US Patent - 5,267,155 this is the foundation of this database design). This is a user definable database. It's a 13year old design. The databases initial design function was to serve as a computer based...

Part and Inventory Search

Back
Top