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?:confused: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.