M
Matthew
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
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