Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #13  
Old 11-02-2018, 11:43 PM
Marcia's Avatar
Marcia Marcia is offline Conditional Formula if a learner comes late in the morning, afternoon or morning and afternoon Windows 7 32bit Conditional Formula if a learner comes late in the morning, afternoon or morning and afternoon Office 2007
Expert
Conditional Formula if a learner comes late in the morning, afternoon or morning and afternoon
 
Join Date: May 2018
Location: Philippines
Posts: 554
Marcia has a spectacular aura aboutMarcia has a spectacular aura aboutMarcia has a spectacular aura about
Default

[quote=p45cal;135050]OK, got the triangles working. Now I'm working on what users might put in, even if they get it a bit wrong - The input error could be prevented by a validation list later on when all the codes shall have been finalized. But I guess the list would over populate the cells and might cause the processing to slow down. I don't see anything wrong with the system re-writing the error into its standard code (i.e. from LLLE to LLEL)

  • Is LE something that can happen EITHER in the morning OR in the morning on the same day? - LE refers to a learner who enrol beyond the cut-off date, in this school year, the cut off date is June 4. There is no morning or afternoon LE. A LE learner comes from the same school.
Is TI something that can happen EITHER in the morning OR in the morning on the same day? - TI refers to transfer in learners, those who come from other schools, so there is no morning or afternoon for TI.


The reason for the presence of the LE, TI, DRP, TO in the form is their effect on the total daily attendance. Say on June 4, there were 10 learners but during the month a learner came in, registered as LE on June 8, making the total daily attendance on Jun 8-31 to 11 learners.


I should be the one to apologize for providing piecemeal information that have relevance to the program.
Reply With Quote
 

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
New learner need help - convert tables in word format to ppt slides. sas Word VBA 5 09-21-2017 08:33 PM
Conditional Formula if a learner comes late in the morning, afternoon or morning and afternoon Good morning/afternoon/evening based on time dwirony Word VBA 1 01-03-2017 01:01 PM
Need conditional formatting formula namedujour Excel 1 05-27-2016 08:58 AM
Conditional Formula if a learner comes late in the morning, afternoon or morning and afternoon Conditional Formatting Formula teza2k06 Excel 1 08-22-2014 02:49 AM
Conditional Formula UICOMP Excel 1 05-18-2012 12:59 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:58 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft