Hoping someone can help!:(

I have a table in access which holds interest rates details, and a query that displays the latest interest rate entered into the table (on the last line) by using the Last option in the Totals field.

The problem is that when I enter any new data into the table the query doesn't see this and continues to display the data which is now on the second to last line. The query for some reason just doesnt seem to notice the new last line.

Is there a solution to this so that it shows the new last line?

Thanks is advance!

When you say 'a query displays' the value, do you mean on a form or a report, or what?

If it's on a form, you may just need to refresh or requery the form, after the alteration has been made.