Results 1 to 2 of 2

Thread: Help, Exam Time

  1. 02-24-2013, 03:56 AM #1
    Painturly
    Painturly is offline Registered User
    Join Date
    Feb 2013
    Posts
    1

    Help, Exam Time

    Hi Everyone: I am a newbee here. I don't want to take up too much time but I am attempting to learn SQL for an exam. Here's the question.
    Can you use a query in ACCESS to multiply the amount purchased and the purchase price to come up with a price for the total order for each customer listed in the database? Can this then be listed by Customer ID?Thank you
    Painturly
    Reply With Quote Reply With Quote
  2. 02-25-2013, 03:24 AM #2
    Allan Murphy
    Allan Murphy is offline Registered User
    Join Date
    Oct 2006
    Location
    Maitland NSW Australia
    Posts
    275
    Yes, you can. Have look at Nortwind.mdb or Nwind.mdb database that came with access. Look at the Record source for the Orders form.
    Allan
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules