Simple query retuning multiple repeated records when none exist

[paul32]

Hello everyone,

I've been scratching my head trying to figure this one out. I've created a simple query with one table that looks at a single field (Invoice_Num) and with the criteria "=87161". The query then shows over 40,000 results with the value 87161 repeated in every single result. What is going on? I've had this happen before and I've dealt with it by using the Group By function, but I don't think I should have to do this every time.

Is this normal query behaviour? Am I missing something fundamental from basic query design? Is there some setting that I accidentally clicked? Thanks, everyone!

[orange]

It sounds like you may have put a constant in a place where a field name was expected.

It would be helpful to readers if you could post the sql of the query. A screenshot or the actual sql is needed to offer more focused answer.

[John_G]

In the query criteria, dont use the = or quotation marks.

Just put 87161 in the criteria box. If the field is text type, Access wil put quotes into the query SQL for you.

[paul32]

Thanks for your reply! By looking at the SQL I was able to find the problem. I had tables in the query that weren't properly joined.

Thanks again orange you made me realize what was wrong with my query!

[orange]

John and I were happy to help.
Good luck with your project.