devxlogo

December 14, 1999

Selecting Rows Based on a Distinct Value

Question: I have a table in my SQL 7 database that, among other values, contains e-mails. There are duplicate e-mail values in this table. I want to extract one record

Exchange Rules Limit

Question: I am trying to set up 87 rules for a specific mailbox. Problem is, I get an error message stating there are too many rules. Is there a limit

Exchange/Outlook Client Lockup

Question: I’ve got a mailbox on our Exchange 5.5 server that locks up Outlook 2000 client after running for a period of time. I’ve tried it on multiple machines so

Finding the Max and Min in Consecutive Data

Question: I have a table in Microsoft Access 97 with sales info in the following format: Prod_Type, Box_Number, Cust_No.FA1111 , 400400 , 40010FA1111 , 400401 , 40010FA1111 , 400402 ,