Last Record of Month

I have a table with records having a Date Field called RepDate. Theserecords are generated each day as part of an end of day processing. Ineed to make a report that selects only the last record for each month.The RepDate may be the last day of the month, or not the last day ofthe month because sometimes the stores are closed on the last day ofthe month (for example, if that day is Sunday or a holiday). How do Ido this? What is the best approach?

That is not really what I need, the last day of a month, because therecord for the last day of the month may not exist. What I am thinkingis sorting by date and using a group and filter somehow, but notexactly sure how. Is there some way to mark each record not to printas it processes through if the next record is part of the same month?How exactly could this be done?

This discussion has been closed.

Welcome to our Community!

If you would like to take part in the discussions, sign in or register for a membership below!