If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
getting date-specific reports
I'm not very sophisticated with Access, but clearly want
to do more than the Access manuals allow for. I know this can be done . . . but I don't know how. Here's the problem. I have created a database that collects information about whether something has been done (yes/no fields) and the date when something WAS done (date fields). I want to create reports from this database that will look for all the YES answers, read the dates associated with the YES answers, and either 1) count the YES answers between specific dates OR 2) provide information (name, phone, etc.) relating to all the YES answers in a certain date range. For instance, during a given week, several new entries are created with YES answers and the date. At the end of the week, we would want to be able to print a report that included ONLY those contacts who said YES. Similarly, at the end of the month, we would like to print a statistical report that included the COUNT of those who said YES. We might also want to change the dates for these reports to indicate other time periods. How do I do this? |
#2
|
|||
|
|||
getting date-specific reports
If you only enter a date when the field is yes, then you don't need to even
look at the yes/no field. All you need to do is find the entries between a date range specified. For example, if you want to find all the records where a field (we'll call it DateCompleted) is inthe month of May, you would simply modify the query upon which your report is based to have the following criteria in the DateCompleted field... between #05/01/04# and #05/31/04# Or to make it more flexible... between [EnterStartDate] and [EnterStopDate] If you include the checkmarks in your report, you would simply add a "count" field to the report or section footer. Unles we knew exactly how your report was built, it would be hard to explain exactly how. Use the help facility and look at "count" and "sum". Rick B "Sabra Briere" wrote in message ... I'm not very sophisticated with Access, but clearly want to do more than the Access manuals allow for. I know this can be done . . . but I don't know how. Here's the problem. I have created a database that collects information about whether something has been done (yes/no fields) and the date when something WAS done (date fields). I want to create reports from this database that will look for all the YES answers, read the dates associated with the YES answers, and either 1) count the YES answers between specific dates OR 2) provide information (name, phone, etc.) relating to all the YES answers in a certain date range. For instance, during a given week, several new entries are created with YES answers and the date. At the end of the week, we would want to be able to print a report that included ONLY those contacts who said YES. Similarly, at the end of the month, we would like to print a statistical report that included the COUNT of those who said YES. We might also want to change the dates for these reports to indicate other time periods. How do I do this? |
#3
|
|||
|
|||
getting date-specific reports
Thanks for the prompt reply. I've done a query, but I
need to automate the report, as I will not be entering data or printing reports. What I'm hoping to learn how to do is create a pop-up that will request the dates for the report. That will then invoke something(!?) that will look at the data and restrict the report to the specified dates. |
#4
|
|||
|
|||
getting date-specific reports
Using my option of
Between [EnterStartDate] and [EnterStopDate] will pop up those questions for the user. This makes it easy to use and flexible. If you wish to create a form that pops up with fields for the two items instead, you can do so. You would have to refer to the form instead of entering prompts like my above example. You'd also have to include code or a macro in your report's "OnOpen" event to have the form open. In the form's "OnClose" event, you'd need to include code to reset the values of those two fields to "" and also close the form (it must remain open while the report prcesses.) I have a similar form and a single button on the form. When clicked, the form is hidden.. My query pulls the data from the form as follows... Between [Forms]![ReportParameters]![EnterStartDate] and [Forms]![ReportParameters]![EnterStopDate] Hope That Helps, Rick B "Sabra Briere" wrote in message ... Thanks for the prompt reply. I've done a query, but I need to automate the report, as I will not be entering data or printing reports. What I'm hoping to learn how to do is create a pop-up that will request the dates for the report. That will then invoke something(!?) that will look at the data and restrict the report to the specified dates. |
#5
|
|||
|
|||
getting date-specific reports
Dear Rick,
I'm still having some difficulties. Would you be willing to look at the database and help me out? |
Thread Tools | |
Display Modes | |
|
|