Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Anonymous
Starting Member
0 Posts |
 Posted - 2000-08-09 : 00:00:00
|
| Sample data-----------ID OPP#400 7641400 6556544 8899544 3456Okay, I have a table like the one above. It was built with the Find Duplicates wizard in Access. ID is the primary key in my machine table and opp# is the primary key in my sales table. Now I want to go through the sales table, where an extra field will be added called Duplicate, and mark all opp#s that are in the table listed above. The only problem is that I dont want the first one to be marked. So opp# 7641 would have an empty duplicate field but opp#6556 would have a flag set (D, 1, or something) in the duplicate field. I have ideas on how to do this via .asp pages but that is not an option. It is basically necessary that this be done within Access. Any ideas on how I would go about this?ThanksO'Cary |
|
|
|
|
|
Marking multiple records