Results 1 to 2 of 2

Thread: MS access

  1. #1
    Join Date
    Jan 2014
    Posts
    1

    Thumbs up Unanswered: MS access

    Dear Members, I want to Autofill one of the field in my form, by checking specific conditions in my database. Example of which is as below:

    1. Date of Maintenance :
    2. Loom No. :
    3. Component Replaced :
    4. Component Type :
    5. Latest date for same component replacement :

    I want to autofill the Sr. No. 5 in the form itself by checking database, and if Sr. No.2=Sr No.3=Sr. 4, then latest date should be autofill in Sr. No. 5

    Say, A component was replaced in a Loom on 01/01/2013 & again after six month same component is replaced on 01/06/2013 so while filling up the form, In sr. no. 5 latest date 01/01/2013 of replacement of same component in same loom should be pulled from data base.

    Pl. help me...

    Thanks in advance

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    so get the current maximum value (use the domain function DMax
    if it cannot find a row that matches it will return null

    so the next Servicer number is:-
    = nz(dmax("myvariable", "mytable", "myCriteria = " & avalue),0)+1
    I'd rather be riding on the Tiger 800 or the Norton

Tags for this Thread

Posting Permissions

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