+ 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, CO
    MS-Off Ver
    MS Office 365 Version 2403 Win 11 Home 64 Bit
    Posts
    23,810

    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.
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Convert Access Expression into VBA
    By carissa80 in forum Access Programming / VBA / Macros
    Replies: 5
    Last Post: 05-26-2017, 09:49 AM
  2. Access Expression Error
    By jeepjenn in forum Access Tables & Databases
    Replies: 2
    Last Post: 04-23-2015, 01:48 PM
  3. Access form works with access Viewer but not full version of Access?
    By Shanyn in forum Access Tables & Databases
    Replies: 1
    Last Post: 10-22-2014, 01:14 PM
  4. Expression
    By Sharon1 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 01-02-2014, 01:50 AM
  5. Need help trying to create Sumif expression in Access
    By delpiero5464 in forum Access Tables & Databases
    Replies: 1
    Last Post: 05-22-2013, 03:12 PM
  6. Expression for Sequential Numbering in An Access Query
    By mcranda in forum Access Tables & Databases
    Replies: 1
    Last Post: 07-05-2012, 06:11 PM
  7. Need VBA expression
    By SDruley in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-03-2012, 01:32 AM

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