Results 1 to 3 of 3
  1. #1
    Join Date
    Apr 2012
    Posts
    2

    Question Unanswered: access project help

    hi guys..

    am taking a a online course and a requirement of the course is to create a database by self learning. There is no material to study so am having millions of questions.

    I am suppose to create a customer/order database......well i have already created tables and forms .

    am stuck in 3 questions where

    1)a query to display the name of the products, services, suppliers
    , which relates to more than one customers, along with
    the name of the customers in a systematic way.

    2). Now create a query to display the name of the customers who have more than one transaction

    3) A report to combine the Last name, Middle name and First name fields as Full_Name (Alias name)


    If somebody can help me ......i will really appreciate..ive searched in the net but could not find any....

  2. #2
    Join Date
    Mar 2009
    Posts
    5,442
    Provided Answers: 14
    Without knowing the structures of the tables, it's very hard to write a query using them.
    Have a nice day!

  3. #3
    Join Date
    Apr 2012
    Posts
    2
    Quote Originally Posted by Sinndho View Post
    Without knowing the structures of the tables, it's very hard to write a query using them.
    here my tables


    Click image for larger version. 

Name:	relationships.jpg 
Views:	7 
Size:	67.1 KB 
ID:	13010

Posting Permissions

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