Results 1 to 2 of 2
  1. #1
    Newbie68 is offline Novice
    Windows 10 Access 2016
    Join Date
    Jul 2020
    Posts
    1

    Query for personnel "status" in Military Organization

    I've created a relational (almost) database for the prior collection of non-relational (excel files in db file format, really).



    I have an "Active" query to reflect who is reported to my training command with (report date > date() and course convene < date() type complexity.

    Now, I would like that query to include a "Status" field. I need to create a leave table with leave purpose, begin and end dates for vacation days away from work, as well as a new Restriction of Movement (ROM) for periods when new students arrive in a 14 day COVID19 quarantine prior to starting a training course.

    What you you recommend? I suppose I need the two tables for both absence reasons and then perhaps I can simply create a case statement in the Active query? Am I "nuking it"?

    Please help.

  2. #2
    ssanfu is offline Master of Nothing
    Windows 7 32bit Access 2010 32bit
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    9,664
    Welcome to the forum...

    Uh, "nuking it"?? Not sure which way you mean.

    You have not provided form names, tables names, table structures not relationships, so providing an answer is extremely difficult.
    A Leave table would probably be good. Where (what table) would you put the leave dates/ROM dates?
    Maybe you would post your dB for analysis? Just need a few records to illustrate the problem. Make up the data - like Mickey Mouse, Fred Flintstone, etc...

    I would build the query "on the fly" because of the filters you want to include. One method is Search criteria by Allen Browne. The code is available in the section "The search code".

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 1
    Last Post: 06-19-2020, 01:57 AM
  2. Replies: 3
    Last Post: 06-06-2018, 08:26 PM
  3. Replies: 1
    Last Post: 09-07-2015, 08:00 AM
  4. Replies: 6
    Last Post: 09-04-2014, 02:03 PM
  5. Replies: 0
    Last Post: 09-25-2008, 12:19 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums