Need Help With Query - dB attached

[DubaiDave]

Hi,

I have been trying to work this out all day with no success at all.

It is a bit hard to explain -

Two tables: Book and Chapters
Book has BookID + Name + Type
Chapters has ChapterID + BookID + ChapterNo + No of Chapter Pages (Chapters are always incremented by one and start at 1)

I want a query that tells me the sum of number of pages in the last chapter for each book type.

I think the answer should be:

History 55
Fiction 70

Can someone please finish the query off for me in the attached dB?

Dave

 

[SOS]

See the query called "qryNumPagesOfLastChapter" how I used two queries to get this.

 

[DubaiDave]

Dear SOS,

Perfect! It does the job and I have also learnt another technique.

Cheers

Dubai Dave