Reports - Show last entry in list

hi,

i have a report that lists the times recorderd as well as other data from other fields IE
time rpm

11.00 100
11.30 120
12.00 140
ETC

i need this list in my report but i also need on the report the last entries

12.00 140 could you please advise me how to do that

thank you
steve

I don't understand your question. Is your report not showing data it should be?

hi,

no the report shows all the results that have been entered into the database
the real results are temperture reading taken at 30 minute intervals when a motor is running as these will go up until the motor is stable

but at the end of the report i need to show a summary of the end readings as this will be when the temperatures are stable and what the customer should expect to see

hope this helps
steve

Think of it in terms of the DATA, not the report. You have records in a table and I presume you are selecting them with a query for your report. If you are interested in the most recent record, that would probably be the record with the highest value for the time, right? You can use a domain function, DMAX() to get that immediately. In case your times run past midnight, that might involve complications, in which case perhaps you can use the Autonumber Primary Key. You DO have an Autonumber Primary Key in your table, I presume.

So you want to repeat the last reading from your process in the report footer?

something like:



If that's the case it's probably going to be a 2 step process, 1 to determine the most recent record (as don described you could get the MAX of your primary key) then do a dlookup of the data within that record to display it on your footer. Any other way you're sort of playing with fire because you won't get consistent results.

hi,

i do not know how to do this , is it possible to create a query with all the feilds in and the put the dlookup or Dlast in the criteria box - is so could you please give me a sample of what needs to be put in it

the feilds are tiime , rtd1 rtd2 rtd3 etc

but the idea is to put the last record in as you have said

steve

If what you want is what I've got you don't do it in a query. You do it on your report.

Assuming your report is ordering things how you want with the most recent record last all you'd have to do is in your report footer section put a series of text boxes where the control source is:

=last([<fieldname>])

where fieldname would be your rtd1, rtd2, rtd3. This will ONLY work if you have sorted your data in your report such that the last record is the one you want repeated.

hi,

i cannot sort it as the records are recorded as they are the temperture can go up as well as down untill the machine is stable . so it is just the last record i need

thanks
steve

thank you
i have manged to get it. as you said i put it on the footer ans all was good

=Last([rtd load results].[rtd 1])

thanks again steve