I have uploaded a raw dbase with Date and Total Sales. I need a monthly cut off total but not 1st-30th of every month, but every 6th to 5th of the following month. Please help thanks.
I have uploaded a raw dbase with Date and Total Sales. I need a monthly cut off total but not 1st-30th of every month, but every 6th to 5th of the following month. Please help thanks.
Make a form that can be set to standard Calendar, or Fiscal Calendar.
(see calendar combo box on image)
All reports used with reference the dates in the text boxes on the form
The FORM is used to set the dates.
The user can set the Fiscal dates or regular date ranges, simply by clicking the month, etc.
The form calculates everything.
You could simply substract 4 days (cutoff day - 1) from the date column to be able to use Month() as the cutoff again. The nice thing here is, that you can simply set any number of the month as cutoff if you make it a form field as described by ranman256, but you don't need to do a between query and can even group on the resulting field.
Can't I do it in a query instead? coz I have more fields other than the totat sales and date of sales. I just deleted it on the attachment to save mb. thanks