Pivot / Sumary Table

[gg09]

Hi. I am working on a simple database to track transactions by date. I was planning to use each record as a date, so I have 1 field for date, 1 for type of transaction, 1 for amount of transaction and 1 for the state. Each has 15 repetitions to input the transactions we do per day. Now, I need to take this and get it to come out in a report similar to a pivot table in excel, showing the transaction dates on the left (vertical) and states on top (horizontal), so that for example, it says that on July 3rd the total transactions were for $500.00.

How do I get this done? I also need totals for both the row and columns.

[bruceR]

First priority: get rid of the repeating fields. Set up a proper data structure with a "parent" and "child" table. You can't do finds, sorts, deletes on reps.

[gg09]

Ok. Thanks Bruce. So, how do I do this. What do you mean by parente /child. Are they identical to each other? What fields do I relate?

Once I do what you are telling me, where do I go from there?