monthly reports

[indians]

I need to create a monthly report. How could I set it up
to only look for those in the month of june 2004? Also,
is there a way to set it up to automatically create a
monthly report for the months to follow.?

 

[Rick B]

You will have to tell us what your database does. Are you a poodle groomer,
or a diamond salesperson, or a RocketEngine Builder? Does your database
track people, things, appointments? Be more specific.

Assuming your records (whatever they are) have a date in them, you can use
your query to only look for records between a specific date range.

Since you might run this on the last day of the month, or the first day of
the next month, I would require the user to enter the desired month, and not
use fancy code to pull it based on the current date.

Rick B


I need to create a monthly report. How could I set it up
to only look for those in the month of june 2004? Also,
is there a way to set it up to automatically create a
monthly report for the months to follow.?

 

[indians]

I apologize. I am running a report to add the total number
of requests for maps. i need to break it down to how many
requests person1 had by calls, faxes, and walkins and so
on.
ie.
representative calls walkins faxes total
person 1 3 2 2 7
person 2 1 4 5 10
total 4 6 7 17

I need to show this per month.
Thanks in advance.

 

[Duane Hookom]

If you are asking how to create a report based on a date range, you should
probably tell us if you have a date field somewhere. Is your sample below an
indication of the field that you have in your table?