Hi everyone. I am trying to work out a WAY of being able to get detailed reports about sales etc when away from our business.

We RUN three epos terminals (touchcreen pcs running XP and pixelpos software). One is the server. Its a fairly large database with Maybe up to 30 fields (possibly more as I have only ever used reports produced by the pixelpos software), daily records go back around 6 years. I have thought of employing and excel expert to map the csv onto a spreadsheet that I would have on a laptop but cost put me off, as did the thought of only being able to use one other pc.

I'd love to have it on a back end to our website to be honest so I could log in and use it like google analytics!!! I fear this would be way too difficult! Could I maybe just use google spreadsheets??

There is a facility on the epos software (pixelpos) to automatically email reports and I think I could get all the info from I need from two of them, maybe once it is set up I could use these reports to keep it up to date??

Forgot to mention that there is indeed Internet access from epos machines and there is also a MAC on the network running iWork, don't know if any mac EXPERTS might think it easier to do in "numbers", or apple script.

I know there is probably a million ways of SETTING this up but I promise free food and beer to the person that can help me set this up!!! (business is a pub/restaurant!!)

Thank you all!!