Totals on a form

[Manuel]

Hello everyone,

I'm trying to create a database in which there is only one table that
contains all of the payables for a company. All the payable invoices have
primarily 3 fields: 'type of cost', 'date due' and 'amount'. The object of
the database is to obtain a printout of expenses categorized by month. It's
supposed to look sort of like this:

Jan Feb Mar
2005 TOTAL

Telephone Expenses
Rent

I've started to do it as a form where each cell is a subform that has a
query as its data source. After about 65-70 cells, print preview works but
when I go to print it, it tells me that it "can't open any more tables".

Is there a way that anybody can suggest to allow a text box (or anything) on
a form to filter records from a table and display a sum of the values in one
of their fields?

Thank you for your help,
Manuel

 

[[MVP] S.Clark]

The explanation of your current method appears to be severely incorrect for
a normalized database. The output layout that you desire can come from a
Crosstab query. You may want to cease further development until such a time
that you understand how the Crosstab query can improve your development
efforts.