Sum Field in report based on field value

[looma123]

I have query with the following field (ID, EmployeeNo, Date, daytype)

Daytype field have one following Value (P,AL,A,SL,H,AWR)

I would like to calculate the following from Type field:
Working Days (P+H)
Absent Days (SL+EL+AL,A)
Payable Days ((P+H+SL)-(EL+AL+A+AWR)

While Absent Without Reason (AWR) will be calculated with 2

[Luuk]

if you have a query, and apparently a question about it, why do you not share this query here?

And what does "P,AL,A,SL,H,AWR" mean?
P = Present
AWR = Absent without Reason
But should the reader here GUESS what the other letters mean?

You would like to calculate somethings like 'Working Days (P+H)'. How would you like to add two values of daytype? (same question for 'Abesent Days' and 'Payable Days'.

Please do NOT assume you are clear when asking a question, but BE CLEAR when you ask a question.

Also give some example data, and what you expect to be outputted by your query.

[twinnyfo]

Looma123,

Welcome to Bytes!

Yes, please post your query. It may also be helpful to understand your table structure.

As Luuk said, it is difficult for us to “guess” what you are trying to do. Please provide a more detailed explanation and we will work through the details.

Thanks!