StrWhere?

[David Whitaker]

I posted a question yesterday about a DLast issue.
After thought, I got to thinking is there a way to go to a specific record
and retrieve a value based off of a date.

I have a database that has got a field which has a date in it. All of the
dates are for the first day of the month(like 10-1-04).
How would you through code find the last month and get a specific
fields(like[onendinv]) value. I would like to use the after update of a
combo box to do this.

 

[Allen Browne]

DMax() will retrieve the latest date, but you want to retrieve another value
based on the latest date.

See:
ELookup - an extended replacement for DLookup()
at:
http://members.iinet.net.au/~allenbrowne/ser-42.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

message
news:%[email protected]...