If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

Unanswered: Joining tables in a select query problem

I have a query in which 2 tables ("Job" and "Customer") are joined by their "CustomerName" attributes. The "Customer" table contains, among other things, the attribute "FaxNumber". One of the attributes in the "Job" table is "JobNumber", which uniquely identifies each job. Running the query returns, correctly, "CustomerName" and "JobNumber" (from the "Job" table) and "FaxNumber" (from the "Customer" table). All records in the database are displayed. However, if I enter a specific Job number into the criteria field for "JobNumber" on the query, I get no records at all. I want to be able to select a single record from its JobNumber.
Why is this happening, and how can I fix it?
Many thanks