Results 1 to 3 of 3
  1. #1
    Cat Ball is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Mar 2023
    Posts
    4

    How do I make a query that shows all the "id" where "number1" is less than "number2"?


    In this case, I want to make a query that only shows id "13" and "15", where "number1" is less than "number2".

  2. #2
    Minty is offline VIP
    Windows 10 Office 365
    Join Date
    Sep 2017
    Location
    UK - Wiltshire
    Posts
    3,003
    This is quite a strange first request - but here you go;

    SELECT ID
    FROM YourTable
    Where Number1 < Number2
    DLookup Syntax and others http://access.mvps.org/access/general/gen0018.htm
    Please use the star below the post to say thanks if we have helped !
    ↓↓ It's down here ↓↓

  3. #3
    Cat Ball is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Mar 2023
    Posts
    4
    thank you!

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

Similar Threads

  1. Replies: 2
    Last Post: 07-07-2021, 02:53 PM
  2. Simple table relationships ("faces" to "spaces" to "chairs")
    By skydivetom in forum Database Design
    Replies: 36
    Last Post: 07-20-2019, 01:49 PM
  3. Replies: 3
    Last Post: 06-06-2018, 08:26 PM
  4. Replies: 6
    Last Post: 06-24-2016, 06:07 AM
  5. Replies: 1
    Last Post: 09-07-2015, 08:00 AM

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
  •  
Other Forums: Microsoft Office Forums