Hi
I have a problem I am trying to filter a query using the MAX function I need to pull results of the latest month and year in the records the year field is the number the month field is text (problem I know) in months 10 11 12 I get one record of each year in all the other months I Gets full results. The main data sheet consists of several queries. How do you solve it?
I have a problem I am trying to filter a query using the MAX function I need to pull results of the latest month and year in the records the year field is the number the month field is text (problem I know) in months 10 11 12 I get one record of each year in all the other months I Gets full results. The main data sheet consists of several queries. How do you solve it?