Results 1 to 6 of 6
  1. #1
    jamesfranklin is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Nov 2012
    Posts
    33

    Display Query

    Hi,

    Table which contain Data


    Name Count Org Desg State

    Frank USA California University Dean California
    James USA Califo University Professor California
    Stephen USA California University Dean California
    Martin USA Califo University Prof California

    Here Display Only That Org_name="Califo University" and Desg="Professor"
    Compare Two Feilds and Display those Records.

    Thank you for ur valuable time in this post...

  2. #2
    alansidman's Avatar
    alansidman is offline VIP
    Windows 7 32bit Access 2010 32bit
    Join Date
    Apr 2010
    Location
    Steamboat Springs
    Posts
    2,529
    Try this:
    Code:
    Select YourTablename.*
    From YourTableName
    Where YourTableName.Org = "Caliifo University" and YourTableName.Desg = "Professor";

  3. #3
    JoeM is offline VIP
    Windows XP Access 2007
    Join Date
    Jun 2012
    Posts
    3,904
    You would just create a query based on that table, add all the fields you want to show, then add Criteria.
    Under the "Org_Name" field, you would enter "Califo University" on the Criteria line
    and under the "Desg" field, you would enter "Professor" on the Criteria line.

  4. #4
    jamesfranklin is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Nov 2012
    Posts
    33
    Hi,

    Thank for ur reply....
    i already tried this query is not working yaaar...


    title given_name family_name remarks
    Associate Professor V ―Alekneviciene CLNA
    Professor Dr Liga Mihej―eva
    Professor Thomas E ―Alekneviciene CLNA


    Display family_name contains '―' and not remarks='clna'
    This is the Specification.....
    Thank you




  5. #5
    JoeM is offline VIP
    Windows XP Access 2007
    Join Date
    Jun 2012
    Posts
    3,904
    Are you doing this is Access or some other language (i.e. SQL)? Contains is not a valid function to use in Access. You would need to use LIKE with wildcards, i.e.
    Like "*-*"

  6. #6
    jamesfranklin is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Nov 2012
    Posts
    33
    Hi,
    Thank u for ur reply i did ...

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

Similar Threads

  1. Replies: 8
    Last Post: 10-22-2012, 07:43 PM
  2. Display Value of another QUERY into a Report
    By taimysho0 in forum Reports
    Replies: 2
    Last Post: 01-09-2012, 08:31 PM
  3. VBA code to display value from SQL query
    By agent- in forum Programming
    Replies: 9
    Last Post: 05-05-2011, 03:52 PM
  4. Display Query Name
    By jgelpi16 in forum Programming
    Replies: 7
    Last Post: 07-20-2010, 08:46 AM
  5. Query to display in single row
    By access in forum Queries
    Replies: 10
    Last Post: 01-14-2010, 11:40 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