Update Record from Query (Max Needed in a Field)

I'm building a database from scratch (to replace a spreadsheet), and I have a
basic understanding of databases and SQL.

The problem that I am having is that I need to pull up member information
(from Members Table), as well as when they last paid their dues (find the Max
value of dues expire field). When I do the Max value for Total though, I
cannot update records any more, because the rest are set to 'Group By'. I've
tried a few other options, but none of them work.

I've uploaded an image of the query to a server that might explain it better
than me.

http://www.gentlepenguin.com/Query_Problem.gif

You can display the max of dues expire in a subform on your main form. If
that doesn't work, consider using a domain aggregate function.

--
Duane Hookom
MS Access MVP

"Matthew" wrote in message
...
I'm building a database from scratch (to replace a spreadsheet), and I
have a
basic understanding of databases and SQL.

The problem that I am having is that I need to pull up member information
(from Members Table), as well as when they last paid their dues (find the
Max
value of dues expire field). When I do the Max value for Total though, I
cannot update records any more, because the rest are set to 'Group By'.
I've
tried a few other options, but none of them work.

I've uploaded an image of the query to a server that might explain it
better
than me.

http://www.gentlepenguin.com/Query_Problem.gif