In a database there has been some problems (like missing unique constraint) and now there are some duplicate product numbers.
select productnr,COUNT(*) from product group by productnr having count...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_21611469.html
I have a bound form to a table called tblRoute.
Fields in the table are Route, Stop, PCT
Each record in the table has a route,stop and PCT.
Route 1 has 24 stops and the user need to renumb...
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_21743879.html
Zones:
MS AccessDate Answered: 02/21/2006 Grade: A Views: 0
Here is the code that I'm using to reposition the stop number in order to reorder the stops in a route. I have a filter in place that only lists those stops within a particular route.
As it stan...
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_21750228.html
Zones:
MS AccessDate Answered: 03/09/2006 Grade: C Views: 0
Hello,
I added 4 buttons to display either 7 string guitar, 6 string guitar, 5 string bass, or a 4 string bass. I noticed that when the bass is selected (both 4 and 5 string bass) the strings ar...
http://www.experts-exchange.com/Programming/Languages/Scripting/JavaScript/Q_21513682.html
Zones:
JavaScriptDate Answered: 08/03/2005 Grade: A Views: 0
In a table, I have a list of questions. Each question has a QuestionNumber which means it is the order the question should be answered. Typically, there are over 125 questions. A question may or...
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_21559092.html
Zones:
MS AccessDate Answered: 09/13/2005 Grade: A Views: 0
We have a network with about 150 users. The subnet mask is 255.0.0.0 - the dchp range is 89.0.0.1 - 89.0.0.254, the server addresses are 89.4.0.1 and on, the printers are 89.3.0.1 and on, etc etc....
http://www.experts-exchange.com/OS/Microsoft_Operating_Systems/Server/2003_Server/Q_216097...
I have a table with a column RoomNumber. It is not the identity column.
It numbers the rooms associated with a house, Room 1, Room 2, Room 3, etc.
If a room is deleted, I need to renumber the ...
http://www.experts-exchange.com/Database/Miscellaneous/Q_21809539.html
Zones:
DatabasesDate Answered: 04/11/2006 Grade: A Views: 0
How can I change the ordinal number of charts on a worksheet or reset the count of chart in the ChartObjects collection.
I have tried deleting all but number 1 and closing the workbook, but when...
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel...
Zones:
MS ExcelDate Answered: 09/17/2006 Grade: A Views: 4
In XL 2003, I do autonumber, but when I add a new blank row, the numbers don't automatically update, can I have it renumber when a blank row is added?
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel...
Zones:
MS ExcelDate Answered: 02/06/2007 Grade: A Views: 0
Can someone tell me a way I can renumber an integer column of all the rows of table, I imagine this will require using cursors however some example code to do this would be excellent
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_20711658.html
