|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
|
Thread Tools | Display Modes |
|
#1
October 15th, 2004, 01:41 PM
|
|||
|
|||
Unmatched Query
I created an “Find Unmatched” Query – comparing a table and a query and
everything worked out fine. Then I created another “Find Unmatched” Query comparing another table and query and it was a mess. The table intially had 1405 records, the query intially had 1348 records – Then I ran the query and the total number of unmatched was 39,826. I noticed that it duplicated A LOT of records – Why would this happen? Thank you 
|
|
#2
October 15th, 2004, 09:20 PM
|
|||
|
|||
|
"Natalia" wrote in message ... I created an "Find Unmatched" Query - comparing a table and a query and everything worked out fine. Then I created another "Find Unmatched" Query comparing another table and query and it was a mess. The table intially had 1405 records, the query intially had 1348 records - Then I ran the query and the total number of unmatched was 39,826. I noticed that it duplicated A LOT of records - Why would this happen? Thank you
|
|
#3
October 15th, 2004, 09:20 PM
|
|||
|
|||
|
"Natalia" wrote in message ... I created an "Find Unmatched" Query - comparing a table and a query and everything worked out fine. Then I created another "Find Unmatched" Query comparing another table and query and it was a mess. The table intially had 1405 records, the query intially had 1348 records - Then I ran the query and the total number of unmatched was 39,826. I noticed that it duplicated A LOT of records - Why would this happen? Thank you
|
|
#4
October 15th, 2004, 09:20 PM
|
|||
|
|||
|
"Natalia" wrote in message ... I created an "Find Unmatched" Query - comparing a table and a query and everything worked out fine. Then I created another "Find Unmatched" Query comparing another table and query and it was a mess. The table intially had 1405 records, the query intially had 1348 records - Then I ran the query and the total number of unmatched was 39,826. I noticed that it duplicated A LOT of records - Why would this happen? Thank you
|
|
#5
October 15th, 2004, 09:21 PM
|
|||
|
|||
|
It sounds like you forgot to join the table and the query.
-- PC Datasheet Your Resource For Help With Access, Excel And Word Applications www.pcdatasheet.com "Natalia" wrote in message ... I created an "Find Unmatched" Query - comparing a table and a query and everything worked out fine. Then I created another "Find Unmatched" Query comparing another table and query and it was a mess. The table intially had 1405 records, the query intially had 1348 records - Then I ran the query and the total number of unmatched was 39,826. I noticed that it duplicated A LOT of records - Why would this happen? Thank you
|
|
#6
October 15th, 2004, 09:21 PM
|
|||
|
|||
|
It sounds like you forgot to join the table and the query.
-- PC Datasheet Your Resource For Help With Access, Excel And Word Applications www.pcdatasheet.com "Natalia" wrote in message ... I created an "Find Unmatched" Query - comparing a table and a query and everything worked out fine. Then I created another "Find Unmatched" Query comparing another table and query and it was a mess. The table intially had 1405 records, the query intially had 1348 records - Then I ran the query and the total number of unmatched was 39,826. I noticed that it duplicated A LOT of records - Why would this happen? Thank you
|
|
#7
October 15th, 2004, 09:21 PM
|
|||
|
|||
|
It sounds like you forgot to join the table and the query.
-- PC Datasheet Your Resource For Help With Access, Excel And Word Applications www.pcdatasheet.com "Natalia" wrote in message ... I created an "Find Unmatched" Query - comparing a table and a query and everything worked out fine. Then I created another "Find Unmatched" Query comparing another table and query and it was a mess. The table intially had 1405 records, the query intially had 1348 records - Then I ran the query and the total number of unmatched was 39,826. I noticed that it duplicated A LOT of records - Why would this happen? Thank you
|
|
#8
October 16th, 2004, 09:25 PM
|
|||
|
|||
|
Probably something is wrong with your unmatched query. Can you post the SQL of
your query? (Possibly unneeded instructions follow) Open the query Select View:Sql from the Menu Select all the text Copy it Paste it into the message Natalia wrote: I created an “Find Unmatched* Query – comparing a table and a query and everything worked out fine. Then I created another “Find Unmatched* Query comparing another table and query and it was a mess. The table intially had 1405 records, the query intially had 1348 records – Then I ran the query and the total number of unmatched was 39,826. I noticed that it duplicated A LOT of records – Why would this happen? Thank you
|
|
#9
October 16th, 2004, 09:25 PM
|
|||
|
|||
|
Probably something is wrong with your unmatched query. Can you post the SQL of
your query? (Possibly unneeded instructions follow) Open the query Select View:Sql from the Menu Select all the text Copy it Paste it into the message Natalia wrote: I created an “Find Unmatched* Query – comparing a table and a query and everything worked out fine. Then I created another “Find Unmatched* Query comparing another table and query and it was a mess. The table intially had 1405 records, the query intially had 1348 records – Then I ran the query and the total number of unmatched was 39,826. I noticed that it duplicated A LOT of records – Why would this happen? Thank you
|
|
#10
October 16th, 2004, 09:25 PM
|
|||
|
|||
|
Probably something is wrong with your unmatched query. Can you post the SQL of
your query? (Possibly unneeded instructions follow) Open the query Select View:Sql from the Menu Select all the text Copy it Paste it into the message Natalia wrote: I created an “Find Unmatched* Query – comparing a table and a query and everything worked out fine. Then I created another “Find Unmatched* Query comparing another table and query and it was a mess. The table intially had 1405 records, the query intially had 1348 records – Then I ran the query and the total number of unmatched was 39,826. I noticed that it duplicated A LOT of records – Why would this happen? Thank you
|
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Unmatched Query not working right? | Matt | Running & Setting Up Queries | 3 | September 15th, 2004 12:30 AM |
| Too Few Parameters error Mail Merge Access Parameter Query | Tony_VBACoder | Mailmerge | 3 | September 14th, 2004 12:15 PM |
| Unmatched Query | Bob Mullen | Running & Setting Up Queries | 1 | July 24th, 2004 02:34 PM |
| Hidden files in Ms-Query cause ODBC connect errors or Query is wac | needyourhelp | General Discussion | 4 | July 12th, 2004 09:38 PM |
| Struggling with MS Query... | Alex | General Discussion | 5 | July 6th, 2004 11:46 AM |
Linear Mode
