Records Different Between Table and Query - Microsoft Access Forum


	Back to Access Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Records Different Between Table and Query

Lee Shastid

12 months ago

Interesting issue here. I have a Products table that has 112 entries in it. I set a query with no search criteria in it. It runs and shows 97 entries. I compared the two and there 15 products not showing on the query. I have tried to re enter those products but it still will not recognize those 15 missing entries even as new ones. I can add another product different than those 15 and it will recognize it in the query. One of the items there is 2 of them one is showing and 1 is not. Any Ideas?

	John Davy @Reply 12 months ago
Hi Lee Please show us the query. We cannot solve an issue unless we see what is going on. John

	Lee Shastid OP @Reply 12 months ago

	Lee Shastid OP @Reply 12 months ago

	Lee Shastid OP @Reply 12 months ago

	Lee Shastid OP @Reply 12 months ago
Here is an example in the Table there is 2 of the item with little variation. One is showing in the query but the other is not. I have even made new query and it does it also.

	Kevin Robertson @Reply 12 months ago
Outer Joins

	Bill Carver @Reply 12 months ago
Kevin is probably right. He usually is. but if what he suggested doesn't work clear out all the criteria you entered. Get them to match, then add your criteria. Run the query as you add the back and you'll find the culprit

	Lee Shastid OP @Reply 12 months ago
Thank you. Its just odd one of the items is almost a duplicate of another , and one shows and the other dont. I guess just a quirk

	A Glenn Yesner @Reply 12 months ago
One thing I noticed about the three items you say don't show in the one screenshot, they don't have a model number. You show part of the criteria in the query design view but not the whole criteria which makes me wonder if the criteria won't bring forth the record without a model number.

	Lee Shastid OP @Reply 12 months ago
I will try to add something and see what happens. Thanks for the catch.

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Forum.

Next Unseen

New Feature: Comment Live View