On Fri, 2005-03-25 at 05:57, CPHennessy wrote: > On Tuesday 22 March 2005 21:25, Alan Frayer wrote: > > I have a relatively large (and growing) MySQL table containing, among > > other things, a varied collection of e-mail addresses. I need to obtain > > a report stating what those addresses are and how many of each exist in > > the table. > > [snip]
> > Is there a function within Calc that will produce a report similar to > > what I'm looking for? > > Can someone show me how to get to where I want to be? > > have you been able to setup a data source in OOo to point to your MySQL > database ? Have a look at http://documentation.openoffice.org for more help. > > Once your datasource is setup then try using File -> Autopilot -> Report > (note: I think that you may have to have Java installed for this to work). Thank you for the suggestion. Linking straight to the MySQL file isn't practical, as the database is on a web server that is not local to me, and I don't want to open any security holes by trying to directly link OOo to the database. I did come across a workable solution, which I'm sharing in case someone else is as weak on spreadsheet functions as I've been. Once the data is downloaded from the web server as a CSV and imported into Calc, I find the COUNTIF() function will give me the data I seek, even if it isn't done as a pretty report, as I had been used to in my database days. I guess I should find the time to actually read the help files... ________________________________________________________________________ Alan Frayer, CNE, CNI, CIW CI, MCP, Net+ - [EMAIL PROTECTED] Member: Independent Consultants Association (ICA) Consultants - FREE Directory Listing - http://www.ica-assn.org --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
