QBE problem

[Guest]

In my database I have users tracking items on different patients. I am trying
to write a report that will inform the user of the last action date (using
Max) and the action. The actions can be alpha or numeric (ex: 24 Hour Call,
Patient Called, Finished). I want a report to tell me the patients last
action, but if the patient has "finished" I don't want them to show up on the
report.

What happens when I use "Max" under Action I get the numeric value of "24
hour call" and when I use "Last" I get the last alph item "Patient Called".

Is there a way that I can use the Max under the date and not use Group by?
Or does anyone have another idea?

Thanks for your help, Ryan

 

[Allen Browne]

See:
Getting a related field from a GroupBy (total) query
at:
http://www.mvps.org/access/queries/qry0020.htm
for 4 ways to solve this.