How to find the Max Value of Different Fields of a Query?

[JithuAccess]

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]

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