+ Reply to Thread
Results 1 to 2 of 2

help on expression for MS Access

  1. #1
    Registered User
    Join Date
    03-26-2012
    Location
    singapore
    MS-Off Ver
    Excel 2007
    Posts
    31

    help on expression for MS Access

    good afternoon all,

    I've created a database to track and manage our leave application. I'm just a beginner and have limited knowledge in expression.
    I need some problems that I'm unable to resolve and hope to receive some help from this forum.
    The following are all the problems:

    1) I need to have a formula that restrict the approver from approving someone for leave when he/she does not have sufficient leave. See Lucy's sample, the leave status is (-) which shouldn't be allowed.
    2) Is there a way I can link up the leave available balance into the Leave application form so that the reviewer has an opportunity to review before deciding to approve or decline?
    3) I need a report that display in calendar format and can do the total count of how many person will be on leave on the same time. Is this possible in access?

    All advice will be very much appreciated and thanks in advance.
    P/s: I was unable to attach the database with Invalid file message..I've saved the table in excel instead for upload purposes. Hope can get some help

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs
    MS-Off Ver
    MS Office 2016
    Posts
    13,375

    Re: help on expression for MS Access

    In your Access File, run a repair and compact and then zip the file and upload the zipped file. In this manner, we can look at the file in its native form. See relationships and have a better understanding of what your db actually looks like.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1