total all records with same job number

[clmoss]

Each record has a job number field and a price field. The job no. may be the same on different records. How can I create another layout with the job no. displayed only once but the total price of all records that contain that job no.

Thanks

[Kurt Knippel]

This was answered in the relationships forum, please do not post into multile forums, only post into the most appropriate one.