I have an Access table called Employee_Work_History_Days with the following fields :

Employee_Id - Text
Work_Date - Date
Payment_Id - Text
Gross - Currency
Week_Number - Number

Employee_Id, Work_Date and Payment_Id make up the primary key.

I need to total up the sum for the Gross for a particular Employee and Week Number. I can do this, but I also need it to ignore a specified Work_Date and Payment_Id.

For instance I need a total for the Gross for employee 'SWE0001' on Week_Number 1, except for the Payment_Id '02' on Work_Date 03/04/2000.

Can anybody help?