I need how to write criteria in append query for max in number field.
for example
if [Year] field is mentioned last five years 2018,2017,2016,2015,2014 i want query to show records for max value which is 2018 and all records before these should be excluded.
I dont want to make another query to get this hence, i am asking if anyone knows how to do it, i cant use the aggregate because their is more fields also on query.
Please provide any criteria that can perform the task.
for example
if [Year] field is mentioned last five years 2018,2017,2016,2015,2014 i want query to show records for max value which is 2018 and all records before these should be excluded.
I dont want to make another query to get this hence, i am asking if anyone knows how to do it, i cant use the aggregate because their is more fields also on query.
Please provide any criteria that can perform the task.