Results 1 to 2 of 2
  1. #1
    jimmy321go is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    May 2012
    Posts
    4

    Query

    Hi



    I am doing a question and I am stuck could anyone tell me how to do a query to list the name and telephone numbers of
    suppliers who have sent invoices dated February 2012.

  2. #2
    orange's Avatar
    orange is offline Moderator
    Windows XP Access 2003
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,849
    We don't do homework here. We answer specific questions and offer some advice/suggestions when asked.

    Since it seems you have a Supplier table, an Invoice Table, I suggest you look at these sites for samples of SELECT queries and try to work it out.

    http://www.w3schools.com/sql/sql_join_inner.asp
    http://www.techonthenet.com/sql/joins.php

    What have you done so far? It's easier to answer a specific question when you can see what the poster has done; what error he received ....
    Post back if you have more questions.

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