Calendar Form creation

zipster1967 · Post by **zipster1967** » Thu Mar 05, 2015 11:55 pm

I want to create a form that displays as a calendar showing the entire month with the dates of all incomes and all expenses and the dates they occur. This is for a personal budget database I am creating. I have tables set up for Incomes, expense types, expense list, and payments I just need to find out the best way to create the form I want to display for getting an overall view of the months budget in a calendar format. Is this possible within base or should I be looking elsewhere for such a thing?

edit this topic's initial post · Post by **Villeroy** » Fri Mar 06, 2015 12:01 am

You want a report. A form is for input. A report shows printable output.
Anyway, SQL is the key.

zipster1967 · Post by **zipster1967** » Fri Mar 06, 2015 1:30 am

Okay then how do I go about creating a monthly claendar report that shows the date and the payments and incomes for each date?

edit this topic's initial post · Post by **Villeroy** » Fri Mar 06, 2015 1:34 am

YOU are the database developer and only YOU know your own data structures. I can not give any advice for something I don't know. The solution is some SQL query.

edit this topic's initial post · Post by **Villeroy** » Fri Mar 06, 2015 1:43 pm

May be something similar to yesterday's topic? viewtopic.php?t=75766

Calendar Form creation

Calendar Form creation

Re: Calendar Form creation

Re: Calendar Form creation

Re: Calendar Form creation

Re: Calendar Form creation