Hey there! Sign in to join this conversationNew here? Join for free
x Turn on thread page Beta

Queries in Access watch

Announcements
    • Thread Starter
    Offline

    0
    ReputationRep:
    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
    Offline

    0
    ReputationRep:
    Sorry mate, i'm Accessed out currently; try grabbing KGSEssex -FatMax on here; he'll no doubt sort you out

    You'll probably need a criterion for orderdetails which reads something like =OrderID
    • Thread Starter
    Offline

    0
    ReputationRep:
    sorted it now anyway, cheers
 
 
 
Reply
Submit reply
Turn on thread page Beta
Updated: April 12, 2006
Poll
Do you agree with the proposed ban on plastic straws and cotton buds?

The Student Room, Get Revising and Marked by Teachers are trading names of The Student Room Group Ltd.

Register Number: 04666380 (England and Wales), VAT No. 806 8067 22 Registered Office: International House, Queens Road, Brighton, BN1 3XE

Write a reply...
Reply
Hide
Reputation gems: You get these gems as you gain rep from other members for making good contributions and giving helpful advice.