Year 12s: what will be the first way you research your future options? >>

Forums
Queries in Access

This discussion is now closed.

Check out other Related discussions

Suggestion: Thread replies on one page or reply search feature
My cas shield
Access to Higher Education (Medicine)
Medicine without completing high school
SFE not replying to letters
Access course to medicine via distant learning
Pursuing medicine with an access course: Is it possible?
Any widening participation mentorship schemes for mature students?
my chance of getting into medicine after 4 rejection last year
Is my Medical school goal realistic?
Aru Cambridge accommodation
Question re: Suspension
SFE Entitlement changed when I changed university.
Would unis accept my qualifications
Access to Medicine East Sussex College EastBourne
Is a Leeds medicine application a grade below typical offer worth pursuing?
Medicine
Graduate studying Access to HE (science)- do I have a shot?
Medicine Application with a nursing degree done internationally
Exeter 2024-entry mmi medicine interview

Queries in Access

Im having problems with this update query im designing. Below is a link to a pic of the relationships set up for this part.

http://i4.photobucket.com/albums/y13...lationship.jpg

Im trying to use an update query so on another record in the database (in the payments table) can be update.

What i want to happen is for all the OrderDetailID's that hold the same OrderID is to total the record totalcostofparticularpart .

ie. for OrderID "1", there are 3 different parts used, Which come under OrderDetailID "1","2","3" . I want it to sum together each of the orderdetailsID's, totalcostofparticularpart.

any help is appreciated