Form based on query problem

[Shaft]

I don't know how I'm going to explain this but here it goes.

I have designed a query that counts and sums the total field of a table grouped by engineer name, which works perfectly, but on the form I am showing the resluts on I want to show the last five totals inputted into the database as well.

I am sure this must be possible some how but I can't get me head round it, any help would be much appreciated.

 

[Shaft]

I have figured out that to pull a foreign value into my form I should the dlookup function, but i am still stuck on the best method to pull the five most recent values. There is a 'date entered' and an autonumber field I can base it around but can't think of the criterea I would have to use.

 

[Shaft]

The problem with using the dlookup is that it will only pull the first value it finds because more than one record will meet the criterea.

Back to square one