Author Topic: OpenOffice Submissions Database  (Read 2797 times)

Unblinking

  • Sir Postsalot
  • Hipparch
  • ******
  • Posts: 8729
    • Diabolical Plots
on: April 07, 2011, 02:21:37 PM
I've posted a freely downloadable submissions database, created in OpenOffice as an ODB file, for anyone who's interested:
http://www.diabolicalplots.com/?p=2069

It has forms for easy entry.  What it lacks is the ability to create certain reports based on queries.  I have an idea what the SQL queries would look like, but am not sure how to use OpenOffice to actually make them happen.  If anyone has experience with such a thing and would like to contribute I'd be much obliged.  (further details about what sort of queries are also at the link)



kibitzer

  • Purveyor of Unsolicited Opinions
  • Hipparch
  • ******
  • Posts: 2228
  • Kibitzer: A meddler who offers unwanted advice
Reply #1 on: April 08, 2011, 03:02:18 AM
I've posted a freely downloadable submissions database, created in OpenOffice as an ODB file, for anyone who's interested:
http://www.diabolicalplots.com/?p=2069

It has forms for easy entry.  What it lacks is the ability to create certain reports based on queries.  I have an idea what the SQL queries would look like, but am not sure how to use OpenOffice to actually make them happen.  If anyone has experience with such a thing and would like to contribute I'd be much obliged.  (further details about what sort of queries are also at the link)

Lemme take a look, see what I can do. Although I'll be doing it in LibreOffice ;-) I'll probably have the chance to check it over the weekend... that OK? pm me with an idea of what reports you want.


kibitzer

  • Purveyor of Unsolicited Opinions
  • Hipparch
  • ******
  • Posts: 2228
  • Kibitzer: A meddler who offers unwanted advice
Reply #2 on: April 08, 2011, 03:04:13 AM
OK just checked your post where you outline the reports so maybe don't worry about contacting me. Although do if you want to. Or don't. Or do.