Search results for query: *

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

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

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

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

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

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

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

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

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

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

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.

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