cash/budgeting systems 1

[NeilBelgium]

dear all,

I am stuck on the possibilities for this one.
I'd like to design a query or several to measure not only current state of affairs by use of money in/money out, but also budgeting for the future.

If I have a list of items, with either the dates they're paid, or the date in the future at which time they SHOULD be paid, how do I ge t a query to display:
a) current state of affairs
b) month by month future breakdown.

all ideas welcome!!

neil

p.s. I've probably overcomplicated matters by having separate tables for moneyout, and money in, which is directly linked to certain projects we undertake. should I lump it all together in the same table?

 

[Jusfire]

For the current state...you may want to try limiting the query by date (including all records today or before) and building whatever expressions you require for that (sum of monies paid, etc).
For the month-by-month future, I might suggest doing the same (limiting them to dates after today) and possibly using a cross table query, forcing each month as a column and compare them to each of the expressions you built earlier (sum of monies paid, etc).

Just an idea of the top of my coffee saturated brain this morning.

 

[NeilBelgium]

many thanks. I'll try this, and if I have problems with the crosstab (which I foresee!) I'll get back to you!