By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
444,154 Members | 2,405 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 444,154 IT Pros & Developers. It's quick & easy.

Finding Dups & deleting the first case

P: 1
I am trying to automate an update in one of my tables, should this be in a query, a module, etc?

I have several fields as follows:

Code1
Code2
EndDate
Count1
Count2

I need it to find the instances where Code1 & EndDate are the same and then update the Count1 field to 0 in all but one of the fields.

I am lost and need to complete this project by the end of the week, any help would be greatly appreciated!
Oct 16 '06 #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.