Building Expression

[report2000]

Hi,
I am trying to create a expression for the following condition:
I am using the regulart drag and drop future of creating the query in Access.

I have two fields:
Number of Employee and Number of Minimum Salary reported

I would like to count the number of employees where there is a minimum salary reported.
If the value is no value (null) exist for the coresponding Number of employee field I would like to ommit the number of emloyees from my calulation

 

[PHV]

SELECT Sum([Number of Employee]) AS TotalNumber
FROM yourTable
WHERE [Minimum Salary] Is Not Null;

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244