Jeff,

Thanks for your reply.

We store the bills with one date on them, and it is that date that I will use
to monitor the "most recent" bill.

Kind Regards,
Russell.

Jeff Boyce wrote:
Russell

Access stores data in tables rather like a "bucket o' data" -- there is no
readily-apparent order.

For Access to give you "the latest entry" requires that you tell Access how
to determine what "latest" means.

I'm assuming you mean "most recent". If so, you'll need to tell Access
which (date/time) field to use to determine "most recent".

You mention "bills" on properties ... are you only interested in when the
bill came in, or also when it is/was due, when it was paid, etc...?

More info, please...

Regards

Jeff Boyce
Microsoft Access MVP

Hi Folks,

[quoted text clipped - 17 lines]
Kind Regards,
Russell.

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...forms/201005/1