It’s been a fun day. There is a long story – not repeated here, that resulted in the need to generate a financial report for an organisation the other half is involved with.

We managed to extract the relevant data from the package that is used [which cannot generate the reports - it isn't flexible enough], and import it into MS Access.

Then, using a combination of the bits I knew about Access, and the SQL that SWMBO* knows from a past life as a database administrator we were able to do a bunch of queries, generate strange measures, do various accumulations and totals and so on. Report done & faxed off, very spiffy looking.

I must admit to being impressed. SQL has always been a mystery to me, so to see somebody enter it and get it to do something useful has been a bit of an eye-opener.

*She Who Must Be Obeyed

Leave a Comment

XHTML: You can use these tags: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

Live Comment Preview

Comment by Somebody

Powered by WordPress 2.8    Rendered in 29 queries and 0.590 seconds.    CleanBreeze Theme