-
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
-
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
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
|
|