Results 1 to 3 of 3

Creating a criteria for multiple columns

  1. #1
    Mrocks22 is offline Novice
    Windows 10 Access 2016
    Join Date
    Jun 2019
    Posts
    2

    Question Creating a criteria for multiple columns


    Hello,
    I don't have much experience with Access and I'm not sure if Access has the capability to do this.
    My table currently has 6 columns ID, Name, Summer, Autumn, Winter and Spring.
    The columns Summer, Autumn, Winter and Spring are all Field type Number.
    I would like to create a query which can look for all names with a number below the inputted number.
    Eg one of my records are ID: 1 , Name: Wolfs-bane , Summer: 17 , Autumn: 18 , Winter: 19 , Spring: 15
    So I could be able to input the season eg Summer and a number eg 17 and the name wolfs-bane would come up.
    Sorry if I'm not specific enough, please tell me if you want another explanation or example.

    Thanks,
    M

  2. #2
    rpeare is offline VIP
    Windows XP Access 2003
    Join Date
    Jul 2011
    Posts
    5,339
    not enough information here.

    If you want to put in 17 and show any record where any season would be equal to or greater than 17 that's one thing
    If you want to put in 17 specifically in the SUMMER column that's another


    realistically this should be in a properly normalized structure like

    Code:
    tblPerson
    P_ID  P_Description
    1     Person A
    2     Person B
    3     Person C
    
    tblSeason
    S_ID  S_Description
    1     Summer
    2     Autumn
    3     Winter
    4     Spring
    
    tblData
    D_ID  P_ID  S_ID  D_Value
    1     1     4     15
    2     1     1     17
    3     1     2     18
    4     1     3     19
    Then you can search all of your data regardless of season or value pretty easily

  3. #3
    Mrocks22 is offline Novice
    Windows 10 Access 2016
    Join Date
    Jun 2019
    Posts
    2
    Could you explain how you could search all the data, because I can't see how.

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

Similar Threads

  1. Replies: 3
    Last Post: 10-18-2016, 08:31 PM
  2. Replies: 3
    Last Post: 06-21-2013, 09:06 AM
  3. Replies: 4
    Last Post: 01-03-2013, 08:29 PM
  4. Replies: 7
    Last Post: 01-02-2013, 11:23 PM
  5. Replies: 10
    Last Post: 03-01-2012, 11:31 PM

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