getting date-specific reports

  • Thread starter Thread starter Sabra Briere
  • Start date Start date
S

Sabra Briere

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?
 
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



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?
 
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.
 
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



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.
 
Dear Rick,

I'm still having some difficulties. Would you be willing
to look at the database and help me out?
 
Back
Top