Results 1 to 5 of 5
  1. 07-20-2023, 05:06 PM #1
    Abdulaym
    Abdulaym is offline Advanced Beginner
    Windows 10 Access 2010 64bit
    Join Date
    Jul 2023
    Posts
    33

    Two fields condition


    Hi, I have two fields: Qty and Available product
    If my Qty > Available Product. Qty should not multiply with the unit price. Thanks for ur usual assistance
    Reply With Quote Reply With Quote
  2. 07-20-2023, 05:22 PM #2
    pbaldy's Avatar
    pbaldy
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,529
    IIf(Qty > Available, 0, Qty * Available)
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com
    Reply With Quote Reply With Quote
  3. 07-21-2023, 12:53 AM #3
    Abdulaym
    Abdulaym is offline Advanced Beginner
    Windows 10 Access 2010 64bit
    Join Date
    Jul 2023
    Posts
    33
    Thanks I really appreciate
    Reply With Quote Reply With Quote
  4. 07-21-2023, 09:45 AM #4
    pbaldy's Avatar
    pbaldy
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,529
    Happy to help!
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com
    Reply With Quote Reply With Quote
  5. 07-22-2023, 10:41 AM #5
    Abdulaym
    Abdulaym is offline Advanced Beginner
    Windows 10 Access 2010 64bit
    Join Date
    Jul 2023
    Posts
    33
    I my to enter this code in my "validation Rule" Thanks
    Reply With Quote Reply With Quote
Please reply to this thread with any new information or opinions.
« Previous Thread | Next Thread »

Similar Threads

  1. A condition to select fields to do mailmerge
    By nt100 in forum Modules
    Replies: 5
    Last Post: 03-04-2018, 07:51 PM
  2. How to condition Making Fields Visible in a Report
    By Juan1313 in forum Programming
    Replies: 2
    Last Post: 06-30-2017, 05:13 AM
  3. Validation condition where at least one of four fields meets the critera
    By Nadine67 in forum Access
    Replies: 6
    Last Post: 07-30-2015, 05:36 PM
  4. How to use Where condition in Macro Access 2010 for two fields
    By coolwhisper in forum Access
    Replies: 7
    Last Post: 02-26-2013, 10:29 AM
  5. Update 2 fields based on where condition.
    By Confused in forum Access
    Replies: 2
    Last Post: 11-19-2009, 05:21 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
  •  

Forum Rules

Other Forums: Microsoft Office Forums