How do set up a report in Access to track monthly spending?

[Guest]

We used the expense report template in Access 2000 to track our expenses. I
need a report that summarizes the monthly expenditures by expense report,
then expense category, subtotals each expense report's totals, then totals
the expenses for that month.

Of course, at the end, I would want a summary all the expense reports for
the year, then the grand total for the year.

 

[Duane Hookom]

Get all the records into a single query. Use this query as the record source
for your report. Set up the sorting and grouping (with headers and footers)
as required. Place totals in the group/report footer sections.

 

[Guest]

Thank you. I believe that will help with what I'm doing. Now next question,
how do you add reports to the same report or do you have to just do separate
reports and just print and collate them? What we're trying to do is find out
how much we spend per month, per year, per class, and per expense category. I
would like, at the end of the monthly report, to attach two reports that
total the annual expenses per class and then the annual expenses per
category. Now that I think about it, isn't there a function that subtotals
everything by month and then totals it by year? I am a real newbie to this,
as I've used queries to do most of my reports and I have no idea how to
design reports.

 

[Guest]

I took your advice and it worked! However, the months are printing in
alphabetical order rather than chronologically and I want the dates to only
be for one year, not to the earliest date in the database.

 

[Duane Hookom]

Set the criteria in the report's record source to only display the current
year.

Don't sort on the text month.

 

[Guest]

Not clear on how to do that.

Set the criteria in the report's record source to only display the current
year.

Don't sort on the text month.

 

[Duane Hookom]

What don't you understand: the criteria or the sorting?

I expect you have a date field. Sort on
=Month([DateField])

 

[marcopolo]

Duane, I'm having the same problem, where does the =Month([DateField])
go?

What don't you understand: the criteria or the sorting?

I expect you have a date field. Sort on
=Month([DateField])

--
Duane Hookom
MS Access MVP
--

Not clear on how to do that.

 

[marcopolo]

I tried the below and got a type mismatch. My field is a combo box with the
months in the Row Source. Below you say dont sort on text. What field
should the month be?

Duane, I'm having the same problem, where does the =Month([DateField])
go?

What don't you understand: the criteria or the sorting?

I expect you have a date field. Sort on
=Month([DateField])

--
Duane Hookom
MS Access MVP
--

Not clear on how to do that.

:

Set the criteria in the report's record source to only display the
current
year.

Don't sort on the text month.

--
Duane Hookom
MS Access MVP


I took your advice and it worked! However, the months are printing in
alphabetical order rather than chronologically and I want the dates to
only
be for one year, not to the earliest date in the database.
:

We used the expense report template in Access 2000 to track our
expenses.
I
need a report that summarizes the monthly expenditures by expense
report,
then expense category, subtotals each expense report's totals, then
totals
the expenses for that month.

Of course, at the end, I would want a summary all the expense reports
for
the year, then the grand total for the year.