If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
Update Record from Query (Max Needed in a Field)
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 |
Thread Tools | |
Display Modes | |
|
|