I'm trying since days to find the right formula with no luck. I have a form called Westwood Night Audit this forms record source is a query with a date field named CHQ#_Acc. I need the query to return a Month to date summery. Like show summery from the first of the month (CHQ#_Acc) to the date in the field.
I tried so many different formulas and nothing worked. I got it to show me the summery for the month till today but I need it to be able to show the summery for a certain day, say I need to see what was the MTD summery for the 10. of the month but today is already the 15.
Thank you in advance for your help.
I tried so many different formulas and nothing worked. I got it to show me the summery for the month till today but I need it to be able to show the summery for a certain day, say I need to see what was the MTD summery for the 10. of the month but today is already the 15.
Thank you in advance for your help.