HOW do i calculate the total order price per ordernr ?

[cody_learn]

HOW do i calculate the total order price per ordernr ?

<img src="" alt="" border="0">

 

[plog]

duplicate post here:

http://www.access-programmers.co.uk/forums/showthread.php?t=287212

Told him he needed to focus on error in relationships before moving on.

 

[cody_learn]

I fixed the errors. How do i calculate the total amount per order? What sql or access changes do i undertake?