By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,620 Members | 1,512 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,620 IT Pros & Developers. It's quick & easy.

Sum Field in report based on field value

P: 1
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
Feb 19 '19 #1
Share this Question
Share on Google+
2 Replies

Expert 100+
P: 1,035
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.
Feb 19 '19 #2

Expert Mod 2.5K+
P: 3,284

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.

Feb 19 '19 #3

Post your reply

Sign in to post your reply or Sign up for a free account.