I’m new to LO and setting up a db previously in Access which was run on a Mac through Parallels, LO on same machine and s/w… Have set up db, forms and reports but am having a problem as when pasted data into Base from Calc its resetting defined Field Types from Date or Decimal to Text (VARCHAR). I am obviously doing something wrong but its driving me mad and have tried many variations to try and sort it! My problem is that am unable to total a column on a report as not Decimal, important report as well. Apologies if a repeat question and many thanks. Phil
Even with this issue have to say am very impressed with the SW and enjoyable using it.
Hello,
In creating a table from Calc data, you need to use the Next button to step through the process & insure the field types are correct. Here is a quick example.
Data in Calc copied. Pasted in Base table section. Used Next button to get to :
You can see amount field is set as varchar.
Make appropriate changes:
When finished:
Note. In this example I let the system generate a primary key field - ID.
Not sure where to answer and thank you! The simplest solution, I was looking too deeply. Thanks very much, Phil