Hi Folks,

I want to pick out of a table only the latest entry that meets my criteria,
and I don't know how to.

I have properties (as a table), and I have property expenses (also as a table)
. I would like to display a report where for each property there is the
latest entry for electric bill, latest entry for gas bill, latest entry for
service charge etc. i.e. the criteria is bill = electric, date = most recent

I am at a loss as to how to go about the instruction for "most recent" entry.


As ever, any help gratefully received.

Kind Regards,
Russell.

--
Message posted via http://www.accessmonster.com