Unanswered: How to generate a report based for a single month/ monthly
I have a report that I want to be able to generate for a month, I have tried setting a parameter on the date field but I can only type in e.g. 16/06/04 in the parameter box which would give me reports for the 16th of the month only, I tried 1/06/04-30/06/04 to get the whole of June but it does not like the syntax.
I also noticed that if a particular date had no report for that day it returned #error on the report. Is this right and if so is there a way to customized it to just be blank instead of the error message, which might be confusing to users. Any suggestions pls.
Can anyone pls. help me on how to get the report for an entire month?
Create parameters in your query. In the date field (if there is only one date field) enter this in the query:
Between[BeginningDate] And [EndingDate]
Also a Form created to search for you would be nice also. If I had time would do a sample for you, but keep checking if the above doesn't work well for you, but it should. What it will do is pop up a Dialog window with the words: BeginningDate and after you enter and click OK another pops up with EndingDate. When you click OK again it fetches the data. Note: whatever you place in the brackets will be asked of the user.
So place the above in the Criteria field in the query.