Recent content by Corr

Think of FD1 and FD1A1 as one field. SAme for FD2 and FD2A1. The reason I chose two fields each is because sometimes the database does not have the name field populated but the address field is and visa versa. So if FD1 IS NULL and FD1A1 IS NOT NULL then the value would still be "1" (FD1...

I have a Table with a list of Defendants in legal suits. I have a report that goes out and one of the fields in the report needs to be a 1 = Loan Signer being sued, 2 = Co-signer of loan being sued, or 3 = Both loan signer and co-signer are being sued. Each record contains a unique field call...

Well I was hoping that someone would have been able to post a query as it would show in Windows SQL so that I could see the format or sytax. From there I would have probably figured out how it goes in the program I was using. I understand it wasn't the most proper forum to post in, but those...

Hello, The following query I'm trying to run takes a really long time. I waited 45 mins and gave up. I need this to run and return the results as quick as possible. The SCACCT Table contains approximately 1.6 Million Records and the SCPAYM Table contains approx. 150,000 records. Here is...

I got it now. I was trying it in access first and had some syntax issues, but both posts helped me and worked great on my SQL Server. Still new to me. Thanks alot. John Systems Manager Boca Raton, FL

Hello All, Here's what I got. TableA contains A list of phone numbers with area codes as so "9545551212". TableB has a list of area codes like 954 561 305 and so on. I need to compare the area code in TableA with the area codes in TableB and...

Yes James I just realized that. I'm not functioning well. Here is the quick run down. I have two tables SCACCT and FLHOMES, both have at least three fields I'm using(FNAME, LNAME, and SSN)I want those three fields to be displayed however duplicate records with SSN as the duplicate removed. With...

The SCACCT Table has the Pri Key for SSN. I want all the columns however I want it to retain only one record per duplicate SSN or after getting my results dumped into a seperate table...have it filterout the DUPS then. Either way is fine just not sure what would be easier. I'm getting over...

Hello, How do I remove duplicate records from a table? I am comparing two tables by customer SSN and the results return several duplicate records. Can some one post a reply that can remove the duplicates prior to dumping my results? Here is a copy of my Query Below: SELECT *...

I uninstalled spybot and rebooted the server. Still cannot access network properties or Iexplorer. Well actually I can access IExplorer, but it wont go to any sites. Internet explorer isn't my main concern, but mentioned it as I think it may be related to my net properties issue. Not sure...

I can manage the computer remotely from the snap-in. I can access my computer just fine from the desktop and start menu. I still cant access the network properties from my network places. I uninstalled Spybot from the machine, but need to do a reboot and cant because I have users on it at the...

Hello All, I have a Windows 2000 Server SP4 and when I try to go to the network properties nothing happens. I needed to change a static IP and had to do it using the command prompt using "netsh". Quite a useful command, but I had never used it until now. I also cannot access any web using...

I'm not familiar with the Netopia's very much, but your situation seems simple. Just connect the HUB/Switch of LAN-A to the HUB/Switch to LAN-B. Since both are in the same IP scheme 10.50.21.x and Subnet Mask of 255.255.255.224 they should all see each other and as long as they are configure to...

Incoming call gets answered by AA immediately. Caller presses "0" for the operator which transfers to extension 240. At that time the caller is getting transfered to the Gen. Delv. Mbox. This is not supposed to happen. It only happens a few times a day. The call is supposed to ring...

Yes. ATDT AVAIL: Y BUSINESS OPEN: Y ANSWER LINES: Y ATDT: 240