How to find the Max Value of Different Fields of a Query? (1 Viewer)

JithuAccess

Member
Local time
Yesterday, 19:27
Joined
Mar 3, 2020
Messages
86
just you can make a new simple query reading from this union query, in the field write :-
MaxDAte: Max(More Info Date)
It will show only the max date
Thanks a lot for your suggestion. I will do that
 

JithuAccess

Member
Local time
Yesterday, 19:27
Joined
Mar 3, 2020
Messages
86
Create a new query and use the Union Query as the source rather than a table.


So what. When you have more than one of something, you have many. It is always better to do things correctly rather than make excuses to take "shortcuts" since "shortcuts" are rarely short and never expandable.
Thanks a lot
 

Users who are viewing this thread

Top Bottom