Trial Balance.

Hi Derek
Thats excellent once i get a bit more done i will attach at some point.  Thanks again for getting back.

PS Just out of curiosity where is the fastreports situated in mvd.

Hi there I have attached a very basic mvd file and the excel file with the trial balance tab which is what i am trying to create.  Thanks for any help.

Hi Alan,
You can't just attach the .vdb file without all of the related .pas, dll, .xml, .ini files etc.
The easiest way is to delete the .exe file from the folder where you're project exists and then create a .zip file and attach it.
Regards,
Derek.

Hi,
Unfortunately, your project still hasn't been uploaded so it's hard to make any focused suggestions.
However, on the strength of the spreadsheet that you provided, I just knocked up an 'Aunt Sally' (so expect the odd fault or two!) that might give you some pointers (see attachment).   Obviously, I've made assumptions about a few things (how you do your 'year end', allowing both credit and debit entries against each category (which I noticed is something you don't) etc etc).  But at this stage, it's really just 'ideas'.
The script really isn't as daunting as it might first appear once you've spent a few minutes going through it (and most of it is to do with the 'cosmetics' rather than the 'heavy lifting' which MVD takes care of automatically).
I've not done any reports as I'm not sure at this stage if this is the way you envisage things.
As for picking up SQL, I'm not really one for sitting down with a book!  Anything I've picked up has been from this Forum and by looking at other people's projects, scripts etc to see how they've tackled things - there's nothing like learning on the job.
Regards
Derek.

Hi Alan,
It doesn't actually take that long - a combination of using a 'template' project and then just some cutting and pasting from other projects and then filling in a few gaps.  And having used MVD for quite a while as well! 
Not sure what you mean about the 'trial balance' - does what's there already not cover that (see 'alan trial balance.jpg' screen capture in the attachment)?
With regard to additional projects, you have 3 basic options
1.  create a new and totally stand-alone project.
2.  put all your projects in one project but don't have any integration or commonality between any of them (see the attachment as the sort of thing where Form0 is just a menu pointing you to each discrete project).
3. put all your projects in one project and try to integrate them - for example, if they share common tables ('members', 'suppliers' etc).
It's 'horses for courses' which, if any, you go for.
Regards,
Derek.