Results 1 to 2 of 2
  1. #1
    Misiek is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Apr 2012
    Posts
    1

    Access - sql

    I am new to Access databases.



    I wrote in sql query: select * from orders where worker_id<>1 and customer_id <> (select customer_id from orders where worker_id=1)

    How to transform it into something like in this screen:
    http://officeimg.vo.msecnd.net/pl-pl/files/936/707/ZA010121161.gif

  2. #2
    Robeen is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    Mar 2011
    Location
    Tulsa, Oklahoma.
    Posts
    1,593
    I'm not sure I understand exactly what you are asking.
    Do you simply want to see your query in 'Query Design Mode' like in the link you provided?

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

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