Multiple Entries in Query Results.....

[wilpeter]

Four sets of eyes have seen your testcase samplings of 9,999 records via spreadsheet and I came up with one-third matches with the two matches on Brand. You say that the expected matches on your real database is 9,999 instead of 12,537. You know this, how? Unfortunately, the database is too big to display and the screen pics don't show the reason for the difficulty.

 

[vbaInet]

Four sets of eyes ....

Make that six, I wear contacts lol

 

[SOS]

Make that six, I wear contacts lol

Eight - I wear glasses...

 

[SOS]

SOS / Wilpeter,

I have now joined Product Code and Brand, and as you can see from the attachments I now get a total of 12,537 results (when I should expect 9,999).

I posted both tables in a previous entry on this thread, can someone else import these into a database and tell me if you get the same issue.

Thanks in advance.

I DID import both tables that you posted and I got the 9,999 just fine by linking the two tables. So, the big question is what is different about your setup than ours.

What service pack are you on for Office 2007? See here for how to find out.

 

[wilpeter]

As I said earlier, the version isn't likely the problem as I'm using 2002 and it corresponds to your results.

 

[SOS]

As I said earlier, the version isn't likely the problem as I'm using 2002 and it corresponds to your results.

You should state who you are corresponding to. Are you saying you get 12,000 in your query using the same method?

 

[ukgthor]

SOS,

Apologies, you didn't previously mention that you had imported the sample tables. The version of access that I am using is in the attached screen capture.

 

[SOS]

I'm wondering if there is an issue with the service pack level on this. I'll have to go look to see if something was fixed in one of the service packs that might be applicable. I will try it on my Access 2007 SP2 install and see what I get.

 

[wilpeter]

You should state who you are corresponding to. Are you saying you get 12,000 in your query using the same method?

Sorry, SOS, I was speaking to the thread-starter. I get 3,333 out of the 9999 records sent via spreadsheets. The join matches 9,999 records and the two criteria cut it to 3,333 matches. However, I still don't know what is the correct/expected number.

 

[SOS]

Sorry, SOS, I was speaking to the thread-starter. I get 3,333 out of the 9999 records sent via spreadsheets. The join matches 9,999 records and the two criteria cut it to 3,333 matches. However, I still don't know what is the correct/expected number.

Actually, it should be 3,333 now that you mention it.