Last function

[TollBoothWillie]

I have two tables, call them Table_A and Table_B.

Table_A
TIME
LOG_MESSAGE

TABLE_B
TIME
ERROR

The times from the two tables are not in sync.

I need a query that displays the last log_message and associated time for each user-defined error. For example, I would like to enter an error string ("unhandled exception" for example) and have the query output to me the last log message before EACH instance of that error.
Any ideas?

 

[dhookom]

Is there any relationship between the tables?
BTW: Time is a name of a function. You should really use something like LogTime and ErrTime.

Duane
MS Access MVP
Find out how to get great answers faq219-2884.