Thanks for your help. Solved my problem. Mary
--- In [email protected], "Mike Bisson" <[EMAIL PROTECTED]> wrote: > Have you tried running the "Find Duplicates" query wizard? This should show > you any duplicate records in your table. > > -----Original Message----- > From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf > Of Sean > Sent: Wednesday, September 14, 2005 8:04 AM > To: [email protected] > Subject: [ms_access] Re: Data duplications > > > I am not sure how to eliminate the duplicate item, but if you do not > want to manually delete them create a first query that groups > everything on the table and then do your calculations to figure out > the commission. > > --- In [email protected], "loginmaryk" <[EMAIL PROTECTED]> wrote: > > I have a MS database that calculates the commission for sales > people, > > the branch managers provide me with the sales data and then database > > (query) calculates the commission. I have about 10,000 or more rows > of > > data every month (in a table), the only problems that I have is > > sometimes branch managers duplicated the data by mistake for example > > we have two rows or more of data that are the same (the same Vendor > # > > and Item #) is there anyway that I can make the query to eliminate > the > > duplications. > > > > Thanking you in advance. > > > > > > > > Yahoo! Groups Links ------------------------ Yahoo! Groups Sponsor --------------------~--> Fair play? Video games influencing politics. Click and talk back! http://us.click.yahoo.com/T8sf5C/tzNLAA/TtwFAA/q7folB/TM --------------------------------------------------------------------~-> Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/ms_access/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
