Very Serious Bug In Access With Linked Tables?

Hi, There seem to be a serious bug in Access 97, and I want to know if anyone has encountered this before.
I tried to describe the problem as best as I can, I also included a flash video to describe everything, here it is:
http://naderchehab.googlepages.com/linkedtablebug.swf (~1 MB)


My database has two tables:
- dbo_InventoryLocation which is linking to SQL Server 2000 via ODBC which contains inventory quantities for each product, and
- tblPRODUCTS_BUSINESS which is linking to another access database on the network and contains product information
(item number, title, description, and a field called "InvCategory" which describes item categories). I wrote a very simple query that links these two tables together:


SELECT tblPRODUCTS_BUSINESS.InvCategory, dbo_InventoryLocation.ItemNumber
FROM tblPRODUCTS_BUSINESS INNER JOIN dbo_InventoryLocation
ON tblPRODUCTS_BUSINESS.Item_Number = dbo_InventoryLocation.ItemNumber
GROUP BY tblPRODUCTS_BUSINESS.InvCategory, dbo_InventoryLocation.ItemNumber
ORDER BY tblPRODUCTS_BUSINESS.InvCategory;


The query really doesn't matter, it's just a test. Now here's the weird part:
when I execute this query, and I scroll down to a specific category and count the number of items in that category, I see about 50 of them.
But if I specify that category as a criteria, I see more than 200!

I also noticed that this problem does not happen when I use non-linked tables.

I hope anyone has an idea what that problem might be, and I hope there is a way around it.

Thanks,

Nader