Query not doing what it is supposed to do

[Guy 1965]

I have an application i have been given but forsome reason one of the queries isnt doing what i expect it to do.
One of the queries "Count Cams" is supposed to be able to look at a particular job number in the imported items table and count the number of cams, this is then reported in the job data screen on the main form coresponding to a particular customer.
Eg customer number 4 has a parts list where there are x number of cams used, but what happens os it counts the total number of cams irrespective of the customer.

Can anyone see the porblem , i have spent several evenings playing and cant seem to fix it.

Cheers
Guy

 

[Rickster57]

count

And you have your criteria for your customernumber in your query set to equal the customernumber on the form?

 

[RuralGuy]

It seems to work for me!!

 

[Rickster57]

Access Version

The computer I am on right now has an older version of Access than what the DB was created in and am unable to open it. Can't help.