Walter Hildebrandt wrote:
I have successfully gone down to where the instructions say GO TO THE
QUERIES SECTION. I could not find the Queries section to create a new query
in SQL view
The main database windows has 4 sections for tables, queries, forms and
reports.
Select "Queries" in the left pane of the window and then "Create query
in SQL view" which opens a simple text editor where you simply paste my
command.
For our simple data collector we use one table and one query.
The table collects all data from the incoming spreadsheets in arbitrary
order, but including an automatic time stamp.
The simple query I suggest rewrites the stamp to "2009-40" (week 40 in
2009).
There are dozends of other options to do something useful with the 3
columns of our table before we use import in Calc.
Did I mention the Sub report builder? No I did not.
http://extensions.services.openoffice.org/project/reportdesign
This tool obsoletes most spreadsheets since it generates grouped and
sorted database reports with charts, conditional formattings,
aggregations in headers and footers.
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
