Forum Discussion
Solved
Select MIN of 4 Dates
Hello Experts, I have been doing some research online but cant seem to get this right. If my dates are D1,D2,D3,D4 from MyTable. How can I show the MIN of those dates? I need to group by [ID...
what do you mean by "current date"? isn't it the same with Date()?
see if the Conditions are met in the new function.
The main problem is an inappropriate table design for a relational database application.
Multiple fields of the same thing, named sequentially. XXX1, XXX2, XXX3, etc. always signal this problem.
This is, by the way, what has to be done in Excel because it lacks the ability to manage data relationally. We're not hampered the same way in Access and shouldn't incorporate inappropriate table designs from Excel.
The way to correct the problem is to properly normalize the tables involved. Here is an excellent series of three or four related blog articles describing the problem in more detail and explaining how to resolve it.