help in query. duplicate records (1 Viewer)
- Thread starter zibzaba
- Start date
ajetrumpet
Banned
- Local time
- Today, 03:32
- Joined
- Jun 22, 2007
- Messages
- 5,638
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.
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.
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.
