Can someone please tell me why the report displays the date as some strange number format when the query displays the date properly? See examples below:
Also, Where are the actual database records stored? Are they in the odb file or in some other format in a seperate folder? I would like to move this database to another computer and would like to have all of the information.
Also, If I add changes to it here and take the odb to the other machine, I don't want to overwrite any records that they already have in place.
Thanks
[Solved] Report Format vs Query Format
-
- Posts: 22
- Joined: Tue Mar 21, 2017 5:22 pm
[Solved] Report Format vs Query Format
Last edited by Hagar Delest on Fri Mar 31, 2017 8:59 pm, edited 1 time in total.
Reason: tagged [Solved].
Reason: tagged [Solved].
Chris Petersen
Open Office 4.1.3
Open Office 4.1.3
- charlie.it
- Volunteer
- Posts: 417
- Joined: Wed Aug 21, 2013 2:12 pm
- Location: Italy
Re: Report Format vs Query Format
Ciao, the date format in the report is serial format. You can re-format it open the report in edit mode.
charlie
Italian AOO Admin
macOS 14 Sonoma M1: Open Office 4.1.15 - LibreOffice 7.5.7.1
http://www.charlieopenoffice.altervista.org
Italian AOO Admin
macOS 14 Sonoma M1: Open Office 4.1.15 - LibreOffice 7.5.7.1
http://www.charlieopenoffice.altervista.org
- charlie.it
- Volunteer
- Posts: 417
- Joined: Wed Aug 21, 2013 2:12 pm
- Location: Italy
Re: Report Format vs Query Format
The records are stored in .odb file. You can move the .odb file to another computer.
If you take the .odb file in another computer the operative system will ask to you if you want replace or keep both files.
If you take the .odb file in another computer the operative system will ask to you if you want replace or keep both files.
charlie
Italian AOO Admin
macOS 14 Sonoma M1: Open Office 4.1.15 - LibreOffice 7.5.7.1
http://www.charlieopenoffice.altervista.org
Italian AOO Admin
macOS 14 Sonoma M1: Open Office 4.1.15 - LibreOffice 7.5.7.1
http://www.charlieopenoffice.altervista.org
-
- Posts: 22
- Joined: Tue Mar 21, 2017 5:22 pm
Re: Report Format vs Query Format
Thanks! That was easy. It's all fixed.
Chris Petersen
Open Office 4.1.3
Open Office 4.1.3