I am having no success getting this thing done. I have designed a little db I use to keep track of expenses and bank account transactions that I've been using for a year or so and it helps greatly, but I need a report that I can't seem to figure out how to do. I've searched several sites but can't find any examples of what I'm trying to do. I'm trying to get a report that shows my monthly bill payments, and the payment dates and amounts that were paid. Like this:
_____________Jan__________Feb___________Mar___________Apr
Payee
Power..........1/3...200.........2/4..250.............3/7..225..........4/5..250
Lease..........1/25..1200.......2/26..1200.........3/21..1200........4/20..1200
Insurance.....1/16..175........2/20..175................0.....................0
........................................ 2/26..350
Water/Gas.....1/6..150........2/10..175............3/3..150..........4/10..175
As you can see I need to have the payment date and payment amount for each payment together under the appropriate month and also as you can see, some months have more than one payment and some have none at all.
This seems to be pretty complicated, at least it is to me, so I appreciate any help anyone can give me. Let me know if I should post more info than I have.
Thanks to all (in advance) for your help.
_____________Jan__________Feb___________Mar___________Apr
Payee
Power..........1/3...200.........2/4..250.............3/7..225..........4/5..250
Lease..........1/25..1200.......2/26..1200.........3/21..1200........4/20..1200
Insurance.....1/16..175........2/20..175................0.....................0
........................................ 2/26..350
Water/Gas.....1/6..150........2/10..175............3/3..150..........4/10..175
As you can see I need to have the payment date and payment amount for each payment together under the appropriate month and also as you can see, some months have more than one payment and some have none at all.
This seems to be pretty complicated, at least it is to me, so I appreciate any help anyone can give me. Let me know if I should post more info than I have.
Thanks to all (in advance) for your help.