Any Microsoft Access Gurus in here?

[LoStMaTt]

I have a small project I'd like to hire someone to do.

Project details:

I have an Access Database that has sales from a bunch of restaurants that come over nightly via ftp and are merged into this database.

I'd like to be able to create some reports from this database that allow us to compare daily sales, weekly, monthly, yearly, etc.

This way we can look at the fluctuations in profits or losses.

Or even compare one store's sales to another.

I tried to do it using the Access 2007 reports thing but I'm no good at it.

Anyone up for it?

Even if it was PHP/Web based to run on an intranet that would be cool.

 

[ripken204]

is any of this stored in a mysql database?
i know how to do it with php/mysql, i havnt used access in years so cant help you there.