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