Results 1 to 2 of 2
  1. #1
    neo651 is offline Competent Performer
    Windows 7 64bit Access 2010 64bit
    Join Date
    Apr 2011
    Posts
    110

    Modular Criteria


    I work on a help desk and a lot of what we do is imaging and deploying new machines. These machines have numerous custom configurations that need to be made based on a variety of variables. I'd like to create a database where I enter the basic information (i.e. User name, machine model, permissions level, etc) and the database generates a checklist based on those parameters.

    The difficulty is because, while most of the items on the to do list are simply "if Model-X then get line-item-Y", some of them are contingent on 2 or even 3 parameters being there. I can't think of a way to make a query that can get values based on combinations of OR and AND statements where the number of ANDs is also variable....does that make sense?

  2. #2
    ItsMe's Avatar
    ItsMe is offline Sometimes Helpful
    Windows 8 Access 2013
    Join Date
    Aug 2013
    Posts
    7,862
    In a query, you would likely use an IIF() inline if statement/function.

    I would use VBA. Maybe some Select Case and If Then Else Statements.

    Also, you can create a custom function and place it in a General/Standard Module. These functions can be incorporated into Query objects.

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

Similar Threads

  1. Replies: 1
    Last Post: 08-15-2016, 05:56 AM
  2. Replies: 2
    Last Post: 04-02-2015, 12:45 PM
  3. Replies: 1
    Last Post: 11-13-2014, 11:34 PM
  4. Replies: 4
    Last Post: 08-30-2014, 10:23 AM
  5. Replies: 5
    Last Post: 08-02-2012, 09:44 AM

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