>> I'm building an MySQL database for a client which will contain >> information about their clients. They are asking for the ability to >> run custom reports. They don't need graphs or charting, but simply >> the >> ability to build a custom query. The data will be in multiple tables. >> They are used to being able to do this in Microsoft Access, which >> this >> project will be replacing. What options are out there for providing >> them a tool such as this? > > I've never done it myself, but it is possible to use MS Access as a > frontend to MySQL. Since they are familiar with Access already, it > might also make it easier for them to use. >
Microsoft Excel and OpenOffice Base can also connect to MySQL. Both provide a simple query interface. If you're using Excel on a Mac I believe you'll need to install Microsoft Query. I also had to install the actualtechnologies.com MySQL ODBC driver. But it's been a couple years so perhaps some of the native drivers are working now. _______________________________________________ UPHPU mailing list [email protected] http://uphpu.org/mailman/listinfo/uphpu IRC: #uphpu on irc.freenode.net
