I don't think I'm fully understanding what you want. The newsreader has
wrapped your lines, and it's a bit difficult to tell where one line ends and
another begins. Or where one table's field list ends and another table's
list begins.
Are you saying that the SQL expression I posted does not return a zero for
the calculated field's value if there is no matching record in Parts table?
Let me see if I'm reading correctly. You want to return records from a table
based on a model (is that CarParts table?), and also show matching records
from another table (is that PartDetails?), and if there is no matching
record in this second table, display a zero instead of a field from that
second table? What do you mean by "when I want to filter for a model it
brings up only those matching records"? By definition, when you filter a
query for a specific value in a field, the query will only select records
that contain that value in that field?
At the end of your question, it appears that you want to return all records
from a CarParts table (regardless of model), and return only matching
records from PartDetails where the record in PartDetails matches the desired
model information? Am I understanding this correctly? What would be the
purpose of all CarParts records if you're just interested in a single model?
Not trying to second-guess what you're doing, but rather to understand the
circumstances of what you want to do... helps to try to figure out the logic
of queries.
Also, can you post what you've tried to use as the SQL statement for the
query that isn't giving you the desired results?