435,620 Members | 1,512 Online
+ 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
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 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! Feb 19 '19 #3