Access query - "Top 1" record anomaly (?)
Posted on 2013-06-10
I just had a query question answered nicely, but it now created a different issue.
The query now outputs a "TOP 1" set of fields that are correct, and match a given Part_ID.
However, I want to be able to give these fields for EACH part on a project - So I was doing a LEFT JOIN between the parts table and the query table (which outputs a TOP 1 result).
Instead of giving the different answer for each part, it only output a single answer, for 1 record.
any ideas of how to fix?