Most recent score in query design view

[notfound]

Hello all,

I would like to find the most recent questionnaire score for a client.

I see there are various posts related to this on the forum, but mots responses are in SQL - I am trying to do this in Access 2002 query design view.

In basic form, I have two main tables - clients and sessions.

Clients contains ID and name.

Sessions looks up ID and name from the clients table, and has session_date and score.

I can use max of date in query design to show the most recent session, but how do I just get it to show the most recent score, rather than scores of all sessions?

Thanks for your time,
notfound

 

[pbaldy]

Query design view is simply a visual representation of the SQL view. Sounds like this will work for you:

http://www.baldyweb.com/LastValue.htm

In design view, the first is a totals query (the icon that looks like an "E").

 

[boblarson]

In design view, the first is a totals query (the icon that looks like an "E").

And a visual -

 

[notfound]

Thanks folks.

I knew about the totals function (sigma button), seems it was the joining function I was missing.

I attach a simple .mdb showing my adaptation of this idea.

cheers folks!