Go Back   Access World Forums > Microsoft Access Discussion > Reports

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 09-23-2019, 10:27 PM   #1
Ravi Kumar
Newly Registered User
 
Join Date: Aug 2019
Posts: 86
Thanks: 106
Thanked 0 Times in 0 Posts
Ravi Kumar is on a distinguished road
report %

dear all ,

in my report I have 5 columns:
1. Area
2. Planned leave(Hrs)
3. unplanned leave(Hrs)
4. Absenteeism(Hrs)
5. Total OT(hrs)

now at the second row I need percentage like below:
1. below sum of Planned leave(Hrs) - I need % of(Planned leave(Hrs)/(Planned leave(Hrs)+unplanned leave(Hrs)) of that particular area.

same like this for other 3 columns also.I have attached a file for your reference.
kindly some one help me.
Attached Images
File Type: jpg Untitled.jpg (71.8 KB, 12 views)

Ravi Kumar is offline   Reply With Quote
Old 09-23-2019, 11:22 PM   #2
June7
AWF VIP
 
June7's Avatar
 
Join Date: Mar 2014
Location: The Great Land
Posts: 2,428
Thanks: 0
Thanked 568 Times in 564 Posts
June7 will become famous soon enough June7 will become famous soon enough
Re: report %

Then build expression in textbox that references textboxes with the data.
__________________
Attach File Manager is below Advanced editor window, click Go Advanced below Quick Reply window. To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
DEBUG! DEBUG! DEBUG!
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
June7 is offline   Reply With Quote
The Following User Says Thank You to June7 For This Useful Post:
Ravi Kumar (09-23-2019)
Old 09-23-2019, 11:46 PM   #3
Ravi Kumar
Newly Registered User
 
Join Date: Aug 2019
Posts: 86
Thanks: 106
Thanked 0 Times in 0 Posts
Ravi Kumar is on a distinguished road
Re: report %

hi june7,
as I am a beginner I didn't get you correctly if I build an expression can it automatically
update to successive rows also.??
could u pls send the syntax please .
Thank you for your time & help.

Ravi Kumar is offline   Reply With Quote
Old 09-23-2019, 11:50 PM   #4
June7
AWF VIP
 
June7's Avatar
 
Join Date: Mar 2014
Location: The Great Land
Posts: 2,428
Thanks: 0
Thanked 568 Times in 564 Posts
June7 will become famous soon enough June7 will become famous soon enough
Re: report %

Textbox with expression will replicate for each record just the same as a textbox bound to a field. The expression will dynamically calculate using data from each record.
__________________
Attach File Manager is below Advanced editor window, click Go Advanced below Quick Reply window. To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
DEBUG! DEBUG! DEBUG!
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
June7 is offline   Reply With Quote
The Following User Says Thank You to June7 For This Useful Post:
Ravi Kumar (09-23-2019)
Old 09-23-2019, 11:58 PM   #5
Ravi Kumar
Newly Registered User
 
Join Date: Aug 2019
Posts: 86
Thanks: 106
Thanked 0 Times in 0 Posts
Ravi Kumar is on a distinguished road
Re: report %

dear june7,
As I already told you I am still learning , could u pls tell me the expression for this??
so that I can follow the same ??

Ravi Kumar is offline   Reply With Quote
Reply

Tags
beginner , report , report calculations

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
[SOLVED] Change report filters and report label caption based on form command newdistrict Reports 6 07-23-2017 12:52 PM
Open report button to select data from 7 list boxes and present in a report Gavin59 Forms 19 03-07-2016 07:16 PM
[SOLVED] Open sub report from main report by selecting report name scopes456 Reports 3 12-15-2015 11:01 AM
Does MS Access Report support Hide/Show fields at the Report View time? accesser2003 General 3 06-13-2014 06:15 AM
Invoice report problem, report show items from previous invoices. saltyseadog Reports 1 04-16-2013 07:30 AM




All times are GMT -8. The time now is 06:41 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World