Table design and Converting a paper form to a Access Report

[John O'Malley]

I need to design a report that matches a form we currently
use. The report has 25 categories of expenses that are
totaled from anywhere from one entry to a hundred entries
per category while some categories may not be used. The
report is filled out and filed monthly.

Presently the database has three tables.
Table One: Daily Records - The fields are:
([date], [description], [account], [transaction type])
Table Two: Accounts - The fields are: ([account], [type])
Table Three: Income - Expense - the fields are:
([transaction type])

Table two and three are lists to autofill table one's
[account] and [type] fields.

Presently, my report, based on a query with totals, totals
the month's activity and lists the totals for each category
from table one. This is fine; but I need to match my
existing form created in Excel that shows categories on the
left and amounts on the right.

I know how to use text boxes to reflect the form's
appearance. It is the matter of having only the total of a
specific category hit an exact spot on the form and to have
nothing show on the categories that have no activity.

I can redesign the tables if needed. I just can not change
the form.

Any ideas?
John

 

[Rolls]

All you need is an intermediate query with a GROUP BY option selected.
That's your record source for the report.

 

[Guest]

How would you implement it?
John