Go Back   Access World Forums > Microsoft Access Discussion > Queries

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 02-15-2010, 05:37 AM   #1
zibzaba
Newly Registered User
 
Join Date: Jan 2010
Posts: 41
Thanks: 0
Thanked 0 Times in 0 Posts
zibzaba is on a distinguished road
Exclamation help in query. duplicate records

hi
plz help me
i am uploading my access 2000 db.
i want that i get no duplicate records in query1.
thnx
Attached Files
File Type: zip final.zip (347.6 KB, 56 views)

zibzaba is offline   Reply With Quote
Old 02-15-2010, 11:56 PM   #2
ajetrumpet
Banned
 
Join Date: Jun 2007
Location: Universe - Local Group - Milky Way Galaxy - Orion Arm
Posts: 5,640
Thanks: 0
Thanked 100 Times in 47 Posts
ajetrumpet has a spectacular aura about ajetrumpet has a spectacular aura about
Send a message via MSN to ajetrumpet Send a message via Yahoo to ajetrumpet
Re: help in query. duplicate records

you have no duplicate records in query 1! use have used DISTINCT ROW. the purpose of that is to do just THAT, give you a distinct ROW. thus, complete ROWS (that is, every field in the rows) have to be identical in order to be suppressed from the query. it is doing what you asked.
ajetrumpet is offline   Reply With Quote
Old 02-16-2010, 06:48 AM   #3
wilpeter
Canadian enthusiast
 
Join Date: Nov 2009
Location: Winnipeg, MB, Canada
Posts: 211
Thanks: 10
Thanked 2 Times in 2 Posts
wilpeter is on a distinguished road
Re: help in query. duplicate records

zibzaba: To recap, you have a FARMER_ORDERS table that is not linked to the LABOR_EXPENSES table or to CUSTOMER_ORDERS or to the two Queries that total your Office & Transport expenses. Thus each is reported uniquely:
Labor 1, farmer 1, customer 1, amount 1, amount 1;
Labor 1, farmer 2, customer 1, amount 1, amount 1;
Labor 1, farmer 3, customer 1, amount 1, amount 1;
Labor 2, farmer 1, customer 1, amount 1, amount 1;
Labor 2, farmer 2, etc.
a total of 9 distinct records.

wilpeter is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
An interesting experiment! Need others opinion on different ODBC query behaviors. Banana Queries 12 07-01-2008 08:48 PM
Removing Duplicate Records after query karthikn7974 Queries 0 05-28-2008 11:39 PM
Help Filtering duplicate records from query Barrelwaves General 6 01-11-2008 06:23 AM
union all query NOT displaying duplicate records cokeblue8 Queries 2 12-10-2007 09:08 AM
filtering duplicate records query problem LVN Queries 3 07-20-2006 04:50 AM




All times are GMT -8. The time now is 09:03 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World