by DrewJensen » Wed Dec 05, 2007 10:31 pm
Couple of things here.
The first is the sorting issue with the Report - sounds like a known issue with the Report Builder, if that is the way you are creating the report there is not much you can do - except perhaps not bring the auto generated pk field into the report at all. That issue is marked as 'to be fixed' for the 2.4 release or OOo.
Now for the table copy problem. The thing here is most likely a problem that the copy table wizard has when writing data to MS Access - the problem is that it often gets the data types incorrect. I am guessing here that you have a Base file 'CONNECTED' to a MS Access ( Jet ) database file, not that you actually imported any data into a Base database.
The easiest way to fix this is to change from an ADO connection to an ODBC connection. The CopyTableWizard seems to work better with ODBC.
In other words start a new Base file wizard, select 'Connect to exisiting database' as you did last time, but this time instead of selecting MS Access select ODBC and follow the prompts. If you don't know how to create an ODBC connection you can find help at the Microsoft website or just ask here and I'll help you with it.
Give that a try though and you may find that the copy table works, then you can look at using a query that limits the records based on a date range, then copy and paste that so that the new table is only those records.
OK.
Former member of The Document Foundation
Former member of Apache OpenOffice PMC
LibreOffice on Ubuntu 18.04