HELP with query to sort by date and last entry

[M.McDoom]

Hello All,

I am fairly new to Microsoft Access, so I'm not really that familiar
with sql. Nevertheless, I want to create a query that updates one table
based on additons to another table that is sorted by last entered date
and change in a risk level.

The 1st table is called Event:

Event ID (autonumber)
Event
Person
Date
Risk Level (which is a lookup of 4 choices)
Description of Event

The 2nd table is Change of Risk Level

Person
Previous Risk Level
New Risk Level
Change of Risk Level ID (autonumber)

So I'm not sure if I really even need the 2nd table but, basically a
person can have more than one event entry. I need the 2nd table to be
updated automatically because I do not want the workers entering data
into that table. The new risk level should be the latest assessed risk
level and the previous risk level needs to be based upon the last
entered risk level sorted by the date. I was thinking about creating a
make table query, but when I try to do that it doesn't give me the data
I'm looking for.

any suggestions would be helpful.

thanks.

 

[M.McDoom]

In addition I would ideally like the query to look like this

Date Person Event Description Previous Risk Level New
Risk Level

 

[Michel Walsh]

Hi,


If the data is NOT to be updated (form the "table2"), then, rather than
making a second table (table2), try to use one of the fourth methods
presented in http://www.mvps.org/access/queries/qry0020.htm, which is about
finding who was the last to borrow each given book, in a library. Same kind
of question as yours, it seems.



Hoping it may help,
Vanderghast, Access MVP

 

[M.McDoom]

Thank you very much this article was certainly insightful and has aided
me in finding a solution.

Cheers!