+ Reply to Thread
Results 1 to 7 of 7

will work this formul on access to find from query

  1. #1
    Registered User
    Join Date
    12-02-2014
    Location
    albania
    MS-Off Ver
    2007
    Posts
    13

    will work this formul on access to find from query

    hello i want to find which students have grade 5 and which have from 8
    so will work this formule
    access.png

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2405 Win 11 Home 64 Bit
    Posts
    23,872

    Re: will work this formul on access to find from query

    Change your And to Or
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  3. #3
    Registered User
    Join Date
    12-02-2014
    Location
    albania
    MS-Off Ver
    2007
    Posts
    13

    Re: will work this formul on access to find from query

    on my exam i fill like this
    eyetuTI.png

  4. #4
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2405 Win 11 Home 64 Bit
    Posts
    23,872

    Re: will work this formul on access to find from query

    Does that give you the expected results?

  5. #5
    Registered User
    Join Date
    12-02-2014
    Location
    albania
    MS-Off Ver
    2007
    Posts
    13

    Re: will work this formul on access to find from query

    Quote Originally Posted by alansidman View Post
    Does that give you the expected results?
    yes, but my professor said with and no how i filled with or ,and i dont get 40 points for this

  6. #6
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2405 Win 11 Home 64 Bit
    Posts
    23,872

    Re: will work this formul on access to find from query

    You can't have and as that is illogical. Using an and means that the value in a record must be equal to five and be greater than 8. This is illogical.

  7. #7
    Registered User
    Join Date
    12-02-2014
    Location
    albania
    MS-Off Ver
    2007
    Posts
    13

    Re: will work this formul on access to find from query

    Quote Originally Posted by alansidman View Post
    You can't have and as that is illogical. Using an and means that the value in a record must be equal to five and be greater than 8. This is illogical.
    yes i know but that is why im confused how can and work with 2 numbers

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. external data from access query criteria doesn't work
    By carol xl in forum Excel General
    Replies: 1
    Last Post: 11-21-2014, 06:46 PM
  2. query filter didn't work in access 2007
    By already in forum Access Tables & Databases
    Replies: 2
    Last Post: 02-24-2010, 10:01 PM
  3. Query work in access 2003 BUT not when using VBA in Excel Cell
    By r_palate in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-01-2008, 07:39 PM
  4. [SOLVED] MS Query cannot find tables in Access database
    By Dennis Cheung in forum Excel General
    Replies: 0
    Last Post: 07-07-2005, 12:05 PM
  5. [SOLVED] Access query does not work in Excel
    By Ake in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-05-2005, 09:05 AM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1