I have a query where I am look at data for a period that is before or equal to the last day of the previous month. To obtain this data I currently have a criteria of "<=[Last Day Of Month]". This involves typing in the last day of the month previous month. As I will be running this query late at might and will not be around to enter the details I am trying to find a solution where the criteria will automatically set the last day of the month for me.
Does anyone have any suggestions?
thanks
Does anyone have any suggestions?
thanks